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?


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Natan <nvivo (AT) mandic (DOT) com.br> writes:
Nope.

With more than two tables, it *can* make a difference. If using 7.4,
see
http://www.postgresql.org/docs/7.4/s...cit-joins.html
Earlier versions were a bit different --- make the obvious change in
the URL to see the corresponding docs for your version.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html