joins

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: joins
Date: 2002-11-04 19:37:42
Message-ID: 01dd01c28439$a48de480$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)virginia(dot)edu

Responses

  • Re: joins at 2002-11-06 01:01:40 from Bruno Wolff III

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2002-11-04 20:02:23 Fw: joins
Previous Message Andrew Sullivan 2002-11-04 19:25:57 Re: HA for high insert volume