pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Aaron Bono <postgresql@aranya.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Can I do this smarter?
Date: Fri, 14 Jul 2006 06:16:16 +0200
Message-ID: <1152850576.6045.15.camel@localhost> (raw)
In-Reply-To: <bf05e51c0607132052l6b95d5b1m67d5620e80e7491e@mail.gmail.com>
References: <1152848488.6045.13.camel@localhost>
	<bf05e51c0607132052l6b95d5b1m67d5620e80e7491e@mail.gmail.com>

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

view thread (5+ messages)  latest in thread

Message-ID: <1152850576.6045.15.camel@localhost>
Permalink:  ../1152850576.6045.15.camel@localhost/
Also on:    postgresql.org/message-id/1152850576.6045.15.camel@localhost

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: J.Kraaijeveld@Askesis.nl, postgresql@aranya.com
  Subject: Re: Can I do this smarter?
  In-Reply-To: <1152850576.6045.15.camel@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox