多个表进行连表查询(3张表)

表A,B,C

 

select * from A as s1

left join B as s2 on s1.id = s2.id

left join C as s3 on s2.x = s3.x

where s1.xxx = ''