我有以下表格:ProfilRightId ProfilId AccessId Right FROM ProfilRights PRINNER JOIN Access A ON PR.AccessId= A.AccessId
INNER JOIN AccessTranslation [AT] ON A.Access
下面的查询工作良好,但我不知道如何使用“Account”表中的AccessID填充“AccessType”,非常感谢您的任何帮助SELECT Name, Dept, Location, AccessIDWHERE TimeStamp > ( ORDER BY TIME_CREATED DESC
FETCH FIRST
”,“地址”:“34 rue du bourbier","phoneNo":633406546,”email“:”claire.maliner@aie-aix.com“,"active":true,"accessId对等”,“地址”:“Titangae 11,2200 Kobenhavn","phoneNo":8659865,”电子邮件“:”david@peergrade.com“,"active":true,"accessIdBosch”