select d_card.[id] as d_id,d_card.card_id,d_card.card_type,d_card.card_company,d_card.card_name,d_card.card_mobile,
(case when (select count(0) from d_group,d_card where d_group.pid=d_card.[id] and d_group.GroupName='广告收客') >0 then '1' else '0' end)
as userSate
from d_card left join d_travel_agency on d_card.card_id=d_travel_agency.[id] where d_card.card_type='travel_agency'
and d_travel_agency.travel_positioning like '%广告收客%'
and d_travel_agency.travel_agency_pro='广东省' and d_travel_agency.travel_agency_city='东莞市'
--------------标示d_card -------------
--------------标示d_group -------------
--------------标示d_card -------------
--------------标示d_group -------------
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
1 XXX XXX
2 UUU UUU
3 UUYZ SSS
这样的结果集, 我想再通过 联合C表 如果 C.Aid Aid为A表的主键,
如果 C.Aid 存在那么得到
A.id A.XX B.xx C.是否存在
1 XXX XXX C.Aid=1 标示存在
2 UUU UUU C.Aid 里面没有 A.id =2的记录那么不能存在。
3 UUYZ SSS
from (d_card left join d_travel_agency on d_card.card_id=d_travel_agency.[id]) left join d_group on d_card.id=d_group.pid
where d_card.card_type='travel_agency' and d_travel_agency.travel_positioning like '%广告收客%'and d_travel_agency.travel_agency_pro='广东省'
and d_travel_agency.travel_agency_city='东莞市'
自己写出来了 ,最后那个d_group.[id] 如果存在不为空,不存在就为空这样的就满足我的条件了。