Advertisement
simonradev

OUTER JOIN

Oct 18th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.21 KB | None | 0 0
  1. SELECT CONCAT(c.FirstName, ' ', c.LastName) AS [CustomerName],
  2.        c.PhoneNumber,
  3.        c.Gender
  4. FROM Customers AS c
  5. LEFT OUTER JOIN Feedbacks AS f
  6. ON c.Id = f.CustomerId
  7. WHERE f.Id IS NULL
  8. ORDER BY c.Id ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement