你是要干什么呢？

要把2個(gè)表關(guān)聯(lián)起來(lái)查詢？

select tbl1.mid,tbl1.tim,tbl2.mid,tb2.timfrom tbl1,tbl2where tbl1.mid = tbl2.mid and tbl1.mid = 9order by tbl1.tim 還是要把2個(gè)表的查詢結(jié)果放到一起？

select mid,tim from tbl1 where mid = 9unionselect mid,tim from tbl2 where mid = 9order by tim