现在有三张表
Agents 里面的字段有cid workId password type
AGRelation 里面有workId Gid
EtGroup 里面有Gid GroupName
select Agents.workId,Agents.name,Agents.type,EtGroup.groupName from (Agents inner join AGRelation on Agents.workId=AGRelation.workId)inner join EtGroup on EtGroup.Gid=AGRelation.Gid
Agents 里面的字段有cid workId password type
AGRelation 里面有workId Gid
EtGroup 里面有Gid GroupName
select Agents.workId,Agents.name,Agents.type,EtGroup.groupName from (Agents inner join AGRelation on Agents.workId=AGRelation.workId)inner join EtGroup on EtGroup.Gid=AGRelation.Gid