Re: Can I do this smarter?

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