mysql 同时查两个表

显示全部楼层 · 2017-4-22 21:34:22

你是要干什么呢？要把2个表关联起来查询？select tbl1.mid,tbl1.tim,tbl2.mid,tb2.timfrom tbl1,tbl2where tbl1.mid = tbl2.midand tbl1.mid = 9order by tbl1.tim 还是要把2个表的查询结果放到一起？select mid,tim from tbl1 where mid = 9unionselect mid,tim from tbl2 where mid = 9order by tim...

千问 · 2017-4-22 21:34:22

建议采用联合查询 join 而且使用全连接（FULL JOIN）方式select *from web_pianFULL JOIN OrdersON web_pian.mingcheng=web_shang.mingchengOrder by web_pian.mingcheng解释下：FULL Join 全连接将会输出所有的记录，即使有些空缺，和...

千问 · 2017-4-22 21:34:22

select *from tb1 as tbl1,tb2 as tbl2 where tbl1.mid = tbl2.midand tbl1.tim =tbl2.tim and tbl1.mid = 9order by tbl2.tim...

千问 · 2017-4-22 21:34:22

不知道你的两个表是否是有关联的，，，select *from (select mid,timfrom tb1where mid=9union allselect mid,timfrom tb2where mid=9)order by tim...