Re: Can I do this smarter?

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: Aaron Bono <postgresql(at)aranya(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can I do this smarter?
Date: 2006-07-14 04:16:16
Message-ID: 1152850576.6045.15.camel@localhost
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Aaron,

On Thu, 2006-07-13 at 22:52 -0500, Aaron Bono wrote:
> SELECT
> invoices.objectid,
> invoices.invoicenumber,
> invoices.invoicedate,
> salesorders.customer,
> customers.customernumber,
> customers.lastname
> FROM invoices
> INNER JOIN salesorders ON (
> salesorders.objectid = invoices.salesorderobjectid
> )
> INNER JOIN customers ON (
> customers.objectid = salesorder.customer
> )
>
> You should do INNER and OUTER joins for connecting the tables by
> their foreign keys.
Thanks for the quick (and working ;-)) response.

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bingham 2006-07-14 14:07:37 Re: Can I do this smarter?
Previous Message Aaron Bono 2006-07-14 03:52:39 Re: Can I do this smarter?