您所在位置：主题：连接查询要加循环吗?
mercedes
[专家分：190] 发布于 2008-04-08 18:24:00
Select p.PropertyNO,p.DistrictName,p.Trade,p.PriceUnit,e.EmpName,e.Tel ,a.AreaName,a.DistrictName
From Area a,Employee e,Property p Where p.Trade = '出租' and e.EmpID=p.EmpID and p.CityName=a.CityName
order by p.PropertyNO
比如这样的连接查询.
From Area a,Employee e,Property p Where p.Trade = '出租' and e.EmpID=p.EmpID and p.CityName=a.CityName
order by p.PropertyNO
比如这样的连接查询.