Re: OT: Relational Algebra Trees

2002-04-16 Thread Victoria Reznichenko
David, Tuesday, April 16, 2002, 3:01:46 PM, you wrote: DA> Cards on the table, I have an assignment in soon and part of the DA> deliverable is to design some relational algebra tree's based on some DA> queries I have been given. DA> This is one of the queries: DA> SELECT id DA> FROM Table1 DA>

OT: Relational Algebra Trees

2002-04-16 Thread David Ayliffe
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