使用UNION联合两个语句即可:select * from a where cid=1UNIONselect * from b where cid=1
select * from a as a, b as b where a.cid=b.cid and a.cid=1是这样吗?