By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,481 Members | 1,213 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,481 IT Pros & Developers. It's quick & easy.

Items included in one list but not in the other

P: n/a
Joe
I have two lists. They both identical, but the second one is shorter
(has less rows).
I want to create a third list that will not include any of the rows
that the second list has.

(let's say that list one has 200 rows, list two had 50 rows, then list
three will have 150).

Aaron
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 12 Jul 2004 10:30:48 -0700, ga*****@aol.com (Joe) wrote:

Hopefully each list has a unique identifier for each row. Then you
might create a query like this:
select * from table2 where MyUniqueField not in (select MyUniqueField
from table1)

-Tom.

I have two lists. They both identical, but the second one is shorter
(has less rows).
I want to create a third list that will not include any of the rows
that the second list has.

(let's say that list one has 200 rows, list two had 50 rows, then list
three will have 150).

Aaron


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.