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: 41326EBE.6080303@mandic.com.br (view raw or flat)
Thread:
Lists: pgsql-novice
Can anyone tell me if there is any difference between these two commands:

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

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?


Responses

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-2014 The PostgreSQL Global Development Group