第1个回答 2008-03-25
select h.communityName,h.Content,n.Title,n.Content,
s.StoreName,s.Content from HOUSE h,NEWS n,STORE s
where h.communityName like ...,h.Content = ...等(你的查询条件)
使用表别名.字段来讲不同表中相同字段名的给分开
第2个回答 推荐于2017-04-22
select HOUSE.*,NEWS.*,STORE.* from HOUSE,NEWS,STORE where HOUSE.CommunityName like '%关键字%'
or HOUSE.CommunityName like '%关键字%'
or HOUSE.Content like '%关键字%'
or NEWS.Title like '%关键字%'
or NEWS.Content like '%关键字%'
or STORE.StoreName like '%关键字%'
or STORE.Content like '%关键字%'本回答被提问者采纳