方法一:
select b.name,a.id,a.name
from T1 a,T2 b
where b.name=a.vguid
方法二:
select b.name,a.id.a.name from T1 a
inner join T2 b on b.name=a.vguid
select b.name,a.id,a.name
from T1 a,T2 b
where b.name=a.vguid
方法二:
select b.name,a.id.a.name from T1 a
inner join T2 b on b.name=a.vguid
(select a.id,a.name,a.vguid
from T1
)a,(select name from T2)b
where b.name=a.vguid
select YWBH as '业务编号',HTH as '合同号',GDH as '工单号',HTSJ as '合同时间',KHMC as '客户名称',LXR as '联系人' , KHDZ as '客户地址' ,XSDB as '销售代表',FZXSJL as '负责销售经理', SSXMJL as '负责项目经理' from xsht_1 where KHMC='{1:KHGS}'这个里面 凡是加粗的 都是T1 里面的数据,存的是T1 里面的VGUID
所以想通过一条语句把它们显示出来
销售代表 ,所属销售经理 和项目经理 都是T1 里的数据 ,但是在T2 里存的都是T1里的VGUID
SELECT DISTINCT T1.NAME FROM T1
INNER JOIN T2
WHERE T2.NAME=T1.vguid方法二:
SELECT DISTINCT T1.NAME FROM T1
WHERE T1.vguid IN
( SELECT DISTINCT T2.NAME FROM T2)
)
YWBH as '业务编号',
HTH as '合同号',
GDH as '工单号',
HTSJ as '合同时间',
KHMC as '客户名称',
LXR as '联系人' ,
KHDZ as '客户地址' ,
a.name as '销售代表',
b.name as '负责销售经理',
c.name as '负责项目经理'
from xsht_1 T2
left join T1 a on t2.XSDB=a.vguid
left join T1 b on t2.FZXSJL =b.vguid
left join T1 c on t2.SSXMJL =c.vguid
from t2 left join t1
on t2.name=t1.vguid
where t1.vguid is not null
select A.NAME from T2 B
inner join T1 A
on A.name = B.vguid