Mysql一对多 

select * from l1 left join s1 on l1.s1_nid = s1.nid
left join color on l1.cos = color.nid
where s1.pray = 'CEO';

　　

 

多对多

　　

posted @ 2017-02-13 19:53  200ML  阅读(537)  评论(0)    收藏  举报