thanks for the response. Will using left joins and 'NULL' values give me the same response that my original query did (in the event of unlimited memory!) ?

I don't really understand the use of NULL in this instance because I have no NULL values in my database and was originally checking for where two values weren't equal.

Thanks again!