既然没有任何关联,分开查询就好了,放在一起查询又怎么显示呢。 select 字段 from (select * from shopa where place=1) as shopa,(select * from shopb where place=1) as shopb