select table1.*,table2.name from table1 left join table2 on table1.id=table2.id where table1.user_name='xxx' union all select table3.*,table4.name from table3 left join table4 on table3.id=table4.id where table3.user_name='eee' limti 10
这样没法查询,求助,谢谢
能指出错误原因更好了
UNION ALL
SELECT table3.*,table4.name FROM table3 LEFT JOIN table4 ON table3.id=table4.id WHERE table3.user_name='eee' LIMIT 10limti->LIMIT
我这里打错了,事实上我写的是limit
SELECT table1.*,table2.name FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table1.user_name='xxx'
UNION ALL
SELECT table3.*,table4.name FROM table3 LEFT JOIN table4 ON table3.id=table4.id WHERE table3.user_name='eee' ) A LIMIT 10
UNION ALL
(SELECT table3.*,table4.name FROM table3 LEFT JOIN table4 ON table3.id=table4.id WHERE table3.user_name='eee' LIMIT 10 )
试下......
我的思路都错了
http://www.ucooper.com/left-join-where.html
(SELECT table1.*,table2.name FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table1.user_name='xxx')
UNION ALL
(SELECT table3.*,table4.name FROM table3 LEFT JOIN table4 ON table3.id=table4.id WHERE table3.user_name='eee')
LIMIT 10