A query that chooses non-matching items

I've never been the most articulate person in the world, so i though
the best way to illustrate the script I am looking for help with, is to
provide you with two tables and the results I require.

Table 1
ProductName1ProductName2Qty
AAAA-12
BBBB-13
CCCC-14

Table2
ProductNameQty
AA2
BB-13
DD6

Desired Results
ProductNameQty
DD6

Regards,
Ciarn(chudson007@.hotmail.com) writes:
> I've never been the most articulate person in the world, so i though
> the best way to illustrate the script I am looking for help with, is to
> provide you with two tables and the results I require.
> Table 1
> ProductName1 ProductName2 Qty
> AA AA-1 2
> BB BB-1 3
> CC CC-1 4
>
> Table2
> ProductName Qty
> AA 2
> BB-1 3
> DD 6
>
> Desired Results
> ProductName Qty
> DD 6

SELECT t2.ProductName, t2.Qty
FROM Table2 t2
WHERE NOT EXISTS (SELECT *
FROM Table1 t1
WHERE t1.ProductName2 = t2.ProductName
AND t1.Qty = t2.Qty)

Or somesuch depending on your exact definition of "matching".

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp