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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
