a.RecId,a.SiteName,a.Herf,a.RecName,a.ScanTime,a.City,a.Price,a.Type,a.FuncId,a.Acreage,a.Phone from ChuShou as a inner join Chuzu as b on a.RecId = b.RecId看行不行
這樣就可以啊Select * From ChuShou as a,Chuzu as b where a.RecId = b.RecId
select a.vv,a.bb,b.aa from 表名as a inner join 表名as b ON a.tt=b.tt
select a.RecId,a.SiteName,a.Herf,a.RecName,a.ScanTime,a.City,a.Price,a.Type,a.FuncId,a.Acreage,a.Phone from ChuShou as a left join Chuzu as b on a.RecId = b.RecId
Select * From ChuShou as a,Chuzu as b where a.RecId = b.RecId
B里有RecId,SiteName,Herf,City,Phone 和BBS
怎样写才能把这2个表里的信息全部查询出来!!!!!