Link to home
Create AccountLog in
Avatar of Mickeys
MickeysFlag for Sweden

asked on

SQL - Colums names?

The customer names also appear in the Person. Contact table. Join the Sales.SalesOrderHeader table to the Person.Contact table. The ContactID column in the Person.Contact table matches the ContactID column in the Sales.SalesOrderHeader table. Display the CustomerID, TerritoryID and OrderDatencolumns along with the name columns.

What's the names for OrderDatencolums and the name colums?
SELECT SSOH.CustomerID, SSOH.TerritoryID, PC.?, PC.?
FROM Person.Contact AS PC
INNER JOIN Sales.SalesOrderHeader AS SSOH ON SSOH.ContactID = SSOH = ContactID

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account