Skip site navigation (1) Skip section navigation (2)

difference between join syntax

From: Natan <nvivo(at)mandic(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: difference between join syntax
Date: 2004-08-30 00:03:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Can anyone tell me if there is any difference between these two commands:

select * from table1, table2 where =
select * from table1 inner join table 2 on =

I checked the query plan for both and they appear exactly the same. But 
in this case, i am working with only two tables in a very simple 
join.... What i would like to know is: in a production environment with 
lots of joins and where clauses, does it make any difference to write in 
one form or in the other, or the joins are like shortcuts to the first form?


pgsql-novice by date

Next:From: Tom LaneDate: 2004-08-30 00:54:20
Subject: Re: difference between join syntax
Previous:From: Anton MelserDate: 2004-08-29 10:15:01
Subject: test, don't read

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group