Advanced Search

SQL SERVER REEMPLAZO DE NOT IN - OUTER JOIN

/ Published in: SQL
Save to your folder(s)
Reemplaza el NOT IN

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT c.CustomerID 
  2. FROM Sales.Customer AS c
  3. LEFT OUTER JOIN Sales.SalesOrderHeaderEnlarged AS h
  4. ON c.CustomerID = h.CustomerID
  5. WHERE h.CustomerID IS NULL;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.