Posted by Your name on 09/03/06 13:56

Hi,

I'm trying to figure out a way to compare two tables, table one has more
entries than table two, I want SQL to compare table one to table two and
spit out and XLS of the enries that exist in table one, but not in table
two.

So far I can't even get my query right...heh

select * from table1 a
left join tabl2 b on a.column=b.column
where a.column exists not b.column


am I missing an "in" in the select portion on my query?

thanks alot for any help.

• Next in forum: Re: Comparing two tables and spitting out an XLS
• Prev in forum: besoin d'un petit coup de pouce
• Thread view: Comparing two tables and spitting out an XLS

[Reply to this message]