mysql 三個table相串連

select a.id,a.name as a_name,b.name as b_name,c.name
from project a left join customer b on a.customer_id = b.id

left join sales c on a.customer_id = c.id