Re: Everlasting SQL query

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Everlasting SQL query
Date: 2004-07-28 10:48:00
Message-ID: 1091011680.909.25.camel@coppola.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joost,

The spelling mistake from below will cause you an unwanted join with the
"customers" table if you have one, which is unconstrained by any where
clause, so it will take a carthesian product of the rest and the
customers table.
If this spelling mistake is just in the mail, please disregard.

Cheers,
Csaba.

> select customer.id, customer.name, orders.id
> from customers, orders
^^^^^^^^^
> order by customer.id, orders.id
> limit 25
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michal Taborsky 2004-07-28 10:48:26 Re: Everlasting SQL query
Previous Message Együd Csaba 2004-07-28 10:19:26 Re: pgadmin III ?