Re: compare 2 tables in sql

<p><font size="2">Hi Jonah,<br /><br /> Just a postscript.  It is important to check<br /> both ways.  Because
(sometimes)vice versa is<br /> not necessarily true.  Case in point below:<br /><br /><br /> blitzen=> select * from
foo<br/> blitzen-> except<br /> blitzen->        select * from moo;<br />  alleleid | markerid | value |
datecreated| datereplaced<br /> ----------+----------+-------+-------------+--------------<br /> (0 rows)<br /><br />
blitzen=><br/> blitzen=> select * from moo<br /> blitzen-> except<br /> blitzen->        select * from
foo;<br/>   some_id | anothrid | value |       datecreated       |    datereplaced    <br />
----------+----------+-------+-------------------------+---------------------<br/>   2892473 |  2810329 | t     |
2008-03-1214:37:18.165 | 3000-01-01 12:00:00<br /> (1 row)<br /><br /><br /> Regards,<br /><br /> Tena Sakai<br />
tsakai@gallo.ucsf.edu<br/><br /><br /> -----Original Message-----<br /> From: Jonah H. Harris [<a
href="mailto:jonah.harris@gmail.com">mailto:jonah.harris@gmail.com</a>]<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 /> On Wed, Mar 19,
2008at 1:56 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:<br /> >  Is there a sql way to compare (in a
diff/cmpsense)<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 /></font>