You're using access? So, open up access's query builder and build the query there. Click on the join lines and you'll be able to edit the join to make it an outer join. Voila.
On 11/6/05, Will Tomlinson <[EMAIL PROTECTED]> wrote: > > Tyler, > > I'm getting this error. It's the same one I've gotten thru this whole > process: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Syntax error (missing operator) in query expression > 'tblSKUoptions_rel.optionSKUID = tblprod_SKUS.SKUID LEFT OUTER JOIN > tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER > JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID'. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
