Hi there

As sub query do away with additional temporary tables, I had been using it for "IN" & "NOT IN".

I have however not be able to use "EXISTS".

I hope someone can suggest some links to examples of subQry.

Thank you.

Try this link: http://msdn.microsoft.com/en-us/library/aa213271(SQL.80).aspx

Thanks B.M for the example with EXISTS; more within the same location. :)