Ok, Cards on the table, I have an assignment in soon and part of the deliverable is to design some relational algebra tree's based on some queries I have been given.
This is one of the queries: SELECT id FROM Table1 WHERE id NOT IN (SELECT id FROM Table2); I have an idea that this query uses a left join after projecting id in both tables. If anyone can help me understand this a bit better, I would REALLY appreciate an email from you. Sorry for posting off-topic. Thanks lots David Ayliffe ICQ# 125646758 MySQL, query, database --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
