joins - Mailing list pgsql-admin

From Jodi Kanter
Subject joins
Date
Msg-id 01dd01c28439$a48de480$de138f80@virginia.edu
Whole thread Raw
Responses Re: joins  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-admin
Can anyone tell me if there is any real difference between the two different ways to create tables joins?
 
select field1, field2 from table1 join table2 using (field3)
 
vs.
 
select field1, field2 from table1, table 2 where table1.field3=table2.field3
 
Thanks
Jodi
 
 

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: HA for high insert volume
Next
From: Jodi Kanter
Date:
Subject: Fw: joins