skanker (1/28/2015)
I changed the query to be thisSELECT
Salesyear
, complete
, amount
FROM
sales
WHERE
customerid = 2
EXCEPT
SELECT
Salesyear
, complete
, amount
FROM
sales
WHERE
customerid = 1
I expected to see 2 rows but returned 1 only. Not sure why (other than me being thick).
EXCEPT Returns distinct rows by comparing the results of two queries.
Given that the last 2 records for client 2 are the same, only one row will be returned
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”