select * from (select a.Col1,a,col2,b.col3,c.col4,'有关系' as t from a join b on a.col1=b.col3 join c on c.col4=b.col3) d group by d.col1,d.col2,d.col3,d.col4,d.t
'有关系'不用加在group by 子句中 select pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,'有关系' as t ……中间部分略 group by pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname
Please Tryselect pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,t as '有关系' --……中间部分略 group by pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,t
group by d.col1,d.col2,d.col3,d.col4,d.t
select pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,'有关系' as t
……中间部分略
group by pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname
Please Tryselect pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,t as '有关系'
--……中间部分略
group by pvc.regionname,city.regionname,GE_employee.employeename,GE_org.orgname,t