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: | Raw Message | Whole Thread | 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
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? |