Switch column within 2 tables
Posted: Fri 21 Aug 2020 00:01
HI,
Here my SQL Query lines code :
SELECT t.Id,
t.Name,
t."État du locataire",
OrganizationId.Name AS "OrganizationId.Name"
FROM User AS t
LEFT OUTER JOIN Organization AS OrganizationId ON t.OrganizationId = OrganizationId.Id
I would like to see the column Organizationid.Name after the t.Name as third column and not the last one
Thanks
Here my SQL Query lines code :
SELECT t.Id,
t.Name,
t."État du locataire",
OrganizationId.Name AS "OrganizationId.Name"
FROM User AS t
LEFT OUTER JOIN Organization AS OrganizationId ON t.OrganizationId = OrganizationId.Id
I would like to see the column Organizationid.Name after the t.Name as third column and not the last one
Thanks