Fw: [ADMIN] joins

[Jodi Kanter]

Title: Message

I think this was meant for the list (see below).     ----- Original Message ----- From: tachung_h To: 'Jodi Kanter' Sent: Monday, November 04, 2002 2:44 PM Subject: RE: [ADMIN] joins I need to work with a group of volunteer developers over the Internet. Developers might be using Window 2000, XP or Linux and produce programs in Tomcat/Java. Is it practical to think that developers would develop with a PostgreSQL database over the Web? This is a development environment, there is no proprietary data in the database.     Regards TaChung Huang (���j��) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jodi Kanter Sent: Monday, November 04, 2002 11:38 AM To: Postgres Admin List Subject: [ADMIN] joins 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 [EMAIL PROTECTED]