select * from srv.masson.dbo.coding a left join masson.dbo.coding b

on a.articlekey = b.articlekey

and a.systemkey = b.systemkey

where b.articlekey is null



this should bring back everything that's isn't present in table b shouldn't
it?



argh



Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853 3317|
Fax. +27 21 854 7953

When I was young, I used to admire intelligent people; as I grow older, I
admire kind people. Abraham Joshua Heschel




MS Sql Server LazyDBA home page