mysql 两表关联 三表关联 四表关联 五表关联 六表关联

两表关联

 	select * FROM A a LEFT JOIN B b  on a.id = b.id

 三表关联

select * FROM A a LEFT JOIN B b  on a.id = b.id LEFT JOIN C c on a.id = c.id

四表关联 

select * FROM A a LEFT JOIN B b  on a.id = b.id LEFT JOIN C c on a.id = c.id LEFT JOIN D d on a.id = d.id 

 五表关联 

select * FROM A a LEFT JOIN B b  on a.id = b.id LEFT JOIN C c on a.id = c.id LEFT JOIN D d on a.id = d.id LEFT JOIN E e on a.id = e.id 

  六表关联 

select a.`name` FROM A a LEFT JOIN B b  on a.id = b.id LEFT JOIN C c on a.id = c.id LEFT JOIN D d on a.id = d.id LEFT JOIN E e on a.id = e.id LEFT JOIN F f on a.id = f.id