SQL EXCEPTION JOIN
I have three files (orderinfo, deliveryinfo and itemlines). The three files entries shall exist as 1 to 1 to many. The files contains orders from 10+ years. Thus data has been migrated several times by various people. I have discovered that the one-to-one-to-many rule has been broken for many orders. I wrote a pgm to [...]

Answer Question   |  May 4, 2010  1:01 AM
SQL, SQL Exception, SQL EXCEPTION JOIN, SQL join