Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Laphan,
You've gone quiet on me. In absence of some meaningful data from you, this is the best I can do (tested in the MS Query SQL window): SELECT SALESCENTRES.NAME, STOCKCATEGORIES.NAME, SPOOLEDINVOICELINES.QUANTITY, SPOOLEDINVOICES.INVOICEDATE FROM ( ( ( SALESCENTRES LEFT JOIN SPOOLEDINVOICES ON SALESCENTRES.SALESCENTREID = SPOOLEDINVOICES.SALESCENTREID ) LEFT JOIN SPOOLEDINVOICELINES ON SPOOLEDINVOICELINES.SPOOLEDINVOICEID = SPOOLEDINVOICES.SPOOLEDINVOICEID ) LEFT JOIN STOCK ON STOCK.STOCKID = SPOOLEDINVOICELINES.STOCKID ) FULL OUTER JOIN STOCKCATEGORIES ON STOCKCATEGORIES.STOCKCATEGORYID = STOCK.STOCKCATEGORYID WHERE SPOOLEDINVOICES.INVOICEDATE '01 APR 2004 00:00:00' AND SPOOLEDINVOICES.INVOICEDATE < '01 AUG 2004 00:00:00' ; -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
100% quandry | Excel Discussion (Misc queries) | |||
COUNTIF quandry | Excel Worksheet Functions | |||
Macro Quandry | Excel Discussion (Misc queries) | |||
macro quandry.....?? | Excel Discussion (Misc queries) | |||
SQL Query Quandry | Excel Programming |