Re: Everlasting SQL query - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Everlasting SQL query
Date
Msg-id 1091011680.909.25.camel@coppola.ecircle.de
Whole thread Raw
In response to Everlasting SQL query  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
List 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
>



pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: pgadmin III ?
Next
From: Michal Taborsky
Date:
Subject: Re: Everlasting SQL query