On Thu, Oct 9, 2008 at 1:48 PM, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
> No, this won't work. Here's an example of my tables:
> Table1
> 1, 12, A
> 2, 16, B
> 8, 6, A
> 19, 9, C
>
> Table2
> 1, 13, D
> 2, 16, B
> 8, 6, B
> 12, 5, A
select * from table1
union
select table2.* from table2 left join table1 on table2.a=table1.a and
table2.b=table1.b where table2.a is null;
(Written in gmail, but you should get the basic idea.)
--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com