从查询结果中继续查询
摘要:
SELECT * FROM ( SELECT a.*,b.BelongFloor,c.id AS UnitID,c.housename AS UnitName FROM [CRM_HouseInfo] a LEFT JOIN [CRM_RoomInfo] b ON a.[ID]=b.[HouseID] LEFT JOIN CRM_HouseInfo c ON a.[ParentID]=c.id... 阅读全文
posted @ 2008-12-18 17:12 优雅小猪 阅读(527) 评论(0) 推荐(0) 编辑