cannot select specific columns

[mburahmeh]

i faced this issue

"{message: "column createdon exist in both table msdyn_workordertype & ntwapp_translation", type: "invalid_join_query"}"

the column existed on both tables so what can i do if i cannot select specific columns ?

[ujjwalguptaofficial]

Hi

You can use "as" for aliasing a column name just like sql. Here is an example -

select Customers.CustomerName as name, Customers.ContactName as cName, Customers.CustomerID as cId from Orders join Customers 
on 
Orders.CustomerID=Customers.CustomerID

[mburahmeh]

Hi

You can use "as" for aliasing a column name just like sql. Here is an example -

select Customers.CustomerName as name, Customers.ContactName as cName, Customers.CustomerID as cId from Orders join Customers 
on 
Orders.CustomerID=Customers.CustomerID

aliasing is working fine but the returned query still contains all columns plus the alias column , what i need is how to select aliasing columns only without other columns

[mburahmeh]

Hello, i added 2 issues to the sqlweb on github, so please take a look. https://github.com/ujjwalguptaofficial/sqlweb/issues

…

On Wed, Aug 28, 2019 at 5:10 AM Ujjwal Gupta ***@***.***> wrote: Hi You can use as for aliasing a column name just like sql. Here is an example - select Customers.CustomerName as name, Customers.ContactName as cName, Customers.CustomerID as cId from Orders join Customers on Orders.CustomerID=Customers.CustomerID — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3?email_source=notifications&email_token=AM72GOCY4BRLSQV6O3QWYHDQGXNCXA5CNFSM4IQGQK32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5JVCJQ#issuecomment-525553958>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AM72GOG54AFCZ6S35BDJOBDQGXNCXANCNFSM4IQGQK3Q> .