When running the following query in access it works fine.
When I try to use it in my vb program through an sql
string, the recordset is not created. I am looking for
any information in trying to do multiple left outer joins.
SELECT ItemInformation.[Order Date], ItemInformation.[Qty
Order],ItemInformation.ITEMNMBR, ItemInformation.ITEMDESC,
ItemInformation.UOMSCHDL,ItemInformation.WRNTYDYS AS
EACHES, ItemInformation.QTYONORD, [QTYONHND]-[ATYALLOC] AS
QTYAVLBLE,ItemInformation.PRIMVNDR,
ItemInformation.VNDITNUM, ItemInformation.PrchUoM,
[CurrentWeek-3SOP].StartWeek,[CurrentWeek-
3SOP].QtyInvoiced, [CurrentWeek-3SOP].QtyOrdered,
[CurrentWeek-2SOP].StartWeek, [CurrentWeek-
2SOP].QtyInvoiced,[CurrentWeek-2SOP].QtyOrdered,
CurrentWeekSOP.StartWeek, CurrentWeekSOP.QtyInvoiced,
CurrentWeekSOP.QtyOrdered FROM ((ItemInformation LEFT JOIN
[CurrentWeek-2SOP] ON ItemInformation.ITEMNMBR =
[CurrentWeek-2SOP].ITEMNMBR) LEFT JOIN [CurrentWeek-3SOP]
ON ItemInformation.ITEMNMBR = [CurrentWeek-3SOP].ITEMNMBR)
LEFT JOIN CurrentWeekSOP ON ItemInformation.ITEMNMBR =
CurrentWeekSOP.ITEMNMBR;
Thanks!