comparing two lists

fishkake · #1 (**permalink**) 03-17-06, 04:43

Lets say I have 3 "lists" (by which I mean columns resulting from a select statement):

List 1:
a
b
c
d

List 2:
a
b
c
d
e
f

Can I return:

List 3
e
f

(i.e. all the records which are in list 2 but not in list 1). It seems strange that I cannot do this.

r937 · #2 (**permalink**) 03-17-06, 06:14

yep, with a LEFT OUT JOIN

Code:

select x
  from ( select  statement ) as list2
left outer
  join  ( select  statement ) as list1
    on list1.x = list2.x
 where list1.x is null

Pat Phelan · #3 (**permalink**) 03-17-06, 09:05

As R937 said, Yes.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech