j-1064772 (1/13/2014)

---

[font="Comic Sans MS"]These two T-SQL statements return the same results.

If Microsoft deemed it necessary to add the EXCEPT command, then what are its advantages over an INNER JOIN [/font]

-- LIST ONLY PRODUCTS THAT ARE ON A WORK ORDER

[font="Courier New"]USE AdventureWorks2008R2;

GO

SELECT ProductID

FROM Production.Product

INTERSECT

SELECT ProductID

FROM Production.WorkOrder ;

USE AdventureWorks2008R2;

GO

SELECT DISTINCT Production.WorkOrder.ProductID

FROM Production.Product

INNER JOIN Production.WorkOrder ON Production.WorkOrder.ProductID = Production.Product.ProductID[/font]