try adding an identity column to each table and use the unique values generated in your "where" clause for each of the large tables.

Thanks for the script.

I have to study this further.

In discussing this further with a colleague, we came up with a solution for appending single records to an output file. Use the...

Thanks for the reply.

I recently had to write a complex COBOL program with imbedded sql commands that read in 2 input files and also had to write out 4 different...