On Thu, Oct 9, 2008 at 3:31 PM, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
> Thanks, but that didn't work. That selected only the records from table1.
That's why I warned you about it being written in gmail. :)
select * from table1
union
select table2.* from table2 left join table1 on table2.a=table1.a and
table2.b=table1.b where table1.a is null;
This should probably do it without the temp table (the first version
was checking for null in the wrong place).
--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com