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
Switch column within 2 tables
Re: Switch column within 2 tables
Many thanks for the guide! Worked for me perfectly!
Re: Switch column within 2 tables
Hello,KPM wrote: ↑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
Thank you for contacting us!
To change the order you can set the required column right after t.Name in your query. Here is what it will look like:
Code: Select all
SELECT t.Id,
t.Name,
OrganizationId.Name AS "OrganizationId.Name",
t."État du locataire"
FROM User AS t
LEFT OUTER JOIN Organization AS OrganizationId ON t.OrganizationId = OrganizationId.Id