Hello All, im trying to execute the below sql statement and i am getting the error.
Msg 169, Level 15, State 1, Line 1
A column has been specified more than once in the order by list .
SELECT TOP 1 customers.CustomerID as customerid,
customers.CompanyName as companyname
FROM customers INNER JOIN orders
on customers.CustomerID = orders.CustomerID