| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: joins |
| Date: | 2002-11-06 01:01:40 |
| Message-ID: | 20021106010140.GA5458@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Nov 04, 2002 at 14:37:42 -0500,
Jodi Kanter <jkanter(at)virginia(dot)edu> wrote:
> 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
The first form fixes the join order while the second allows the planner to
choose what order to do the joins in. For just two tables this doesn't
make a difference.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michiel Lange | 2002-11-06 07:10:46 | Re: Linux system panic |
| Previous Message | Murthy Kambhampaty | 2002-11-05 19:43:40 | Re: Bug in psql's "-R" option? |