SQL Bribery
Saturday, December 28, 2019
SQL - Left Join and Left Outer Join
SELECT
OrderNumber
,
TotalAmount
,
FirstName
,
LastName
,
City
,
Country
FROM
Customer
C
LEFT
JOIN
[Order]
O
ON
O
.
CustomerId
=
C
.
Id
ORDER
BY
TotalAmount
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment