SQL Server, SSRS and Crystal Reports
Tuesday, 4 January 2011
Using the EXCEPT clause - SQL
--
--example EXCEPT clause....lists EstablishmentID without corresponding Jobs
--
SELECT
EstablishmentID
FROM
Establishment
EXCEPT
SELECT
JobLog_EstablishmentID
FROM
JobLog
ORDER BY
EstablishmentID
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment