Thank you all very much. This will help us to better understand these relationships. I am looking through Adventureworks database diagrams and I am able to see a...

Actually these are questions submitted to me by some coworkers taking a training course. I wanted to demonstrate the use of this resource for them.

Well, the statement executes now that I made the syntax changes, thanks! No I have to deal with the log and cursor issues. :crazy:

I have left work but I recall the message stating that the database name was not valid or something similar, I'll check it out tomorrow. Sometimes I was...

That is correct.

Thanks

No I do not want the records from table 1 if they exist in table 2 or table 3.

Thanks for the advice, that worked!