--把查询出来的结果.当成派生表不行吗? --形如: select * from tb A left join (select col1,col2,.. from tb1) B on A.id = B.col1
SELECT a.member_name,b.company_name,c.province_name FROM dbo.SYS_MEMBER where member_id not in ( SELECT MEMBER_ID FROM dbo.MEMBER_CLAIMED_DATA WHERE (CREATE_DATE BETWEEN '2006-2-1' AND '2007-2-1') ) a left join dm_dist_dealer b on a.rcode=b.rcode left join china_map c on b.city_id=c.city_id 楼主根据实际情况修改就可以啦。 祝你好运!!
--形如:
select * from tb A left join (select col1,col2,.. from tb1) B on A.id = B.col1
FROM dbo.SYS_MEMBER
where member_id not in (
SELECT MEMBER_ID
FROM dbo.MEMBER_CLAIMED_DATA
WHERE (CREATE_DATE BETWEEN '2006-2-1' AND '2007-2-1')
) a
left join dm_dist_dealer b on a.rcode=b.rcode
left join china_map c on b.city_id=c.city_id
楼主根据实际情况修改就可以啦。
祝你好运!!