先在原来的那个表中取得tag,然后用e_free和他们left outer join 因为你没有提供表结构和测试数据,只能大致写,具体你在仔细调整 select a.*,b.* from e_free b left outer join ( select a.tag b.company,b.linkman,a.dalei,a.[id],a.[datetime],a.cpname,a.quyu,a.jtquyu from (select * from e_ly_dl_qg e where (e.renzheng=1 and e.tag='代理') or (e.tag='留言' and e.dalei in('服装品牌','招商'))) as a inner join e_users as b on b.id=a.huiyuanid order by a.zjsxshijian desc,a.[datetime] desc ) a on a.tag = b.tag
这样做是不是不能实现啊!!!
等高手解答
因为你没有提供表结构和测试数据,只能大致写,具体你在仔细调整
select a.*,b.* from e_free b
left outer join
(
select a.tag b.company,b.linkman,a.dalei,a.[id],a.[datetime],a.cpname,a.quyu,a.jtquyu
from (select * from e_ly_dl_qg e where (e.renzheng=1 and e.tag='代理') or (e.tag='留言' and e.dalei in('服装品牌','招商'))) as a inner join e_users as b on b.id=a.huiyuanid order by a.zjsxshijian desc,a.[datetime] desc
) a
on a.tag = b.tag