Re: compare 2 tables in sql

<p><font size="2">Fantastic!  Many thanks.<br /><br /> Regards,<br /><br /> Tena Sakai<br /><br /><br /> -----Original
Message-----<br/> From: pgsql-sql-owner@postgresql.org on behalf of Jonah H. Harris<br /> Sent: Wed 3/19/2008 3:39
PM<br/> To: Tena Sakai<br /> Cc: pgsql-sql@postgresql.org<br /> Subject: Re: [SQL] compare 2 tables in sql<br /><br />
OnWed, Mar 19, 2008 at 1:56 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:<br /> >  Is there a sql way to
compare(in a diff/cmp sense)<br /> >  2 tables?  For example,<br /><br /> SELECT * FROM foo<br /> EXCEPT<br />
SELECT* FROM moo;<br /><br /> --<br /> Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324<br /> EnterpriseDB
Corporation| fax: 732.331.1301<br /> 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com<br /> Edison, NJ
08837| <a href="http://www.enterprisedb.com/">http://www.enterprisedb.com/</a><br /><br /> --<br /> Sent via pgsql-sql
mailinglist (pgsql-sql@postgresql.org)<br /> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-sql">http://www.postgresql.org/mailpref/pgsql-sql</a><br/><br /></font>