Home > mailing lists

join and where clause equivalent ? - Mailing list pgsql-novice

From	Nabil Sayegh
Subject	join and where clause equivalent ?
Date	June 10, 2003 12:08:53
Msg-id	1055246895.31783.3.camel@billy Whole thread Raw
Responses	Re: join and where clause equivalent ? (Dmitry Tkach <dmitry@openratings.com>)
List	pgsql-novice

Tree view

Hi all,

is

"SELECT * FROM a JOIN b USING (id_a)"

fully equivalent to

"SELECT * FROM a, b WHERE a.id_a=b.id_a" ?

Which is faster ?

TIA
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

pgsql-novice by date:

From: Dani Oderbolz
Date: 10 June 2003, 11:55:37
Subject: Re: Question regarding keyword checkboxes in database design

From: Dmitry Tkach
Date: 10 June 2003, 14:56:40
Subject: Re: join and where clause equivalent ?

join and where clause equivalent ? - Mailing list pgsql-novice

Previous

Next