SQL多表查询语句怎么写？

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 '%关键字%'

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 = ...等（你的查询条件）

使用表别名.字段来讲不同表中相同字段名的给分开