Hello, I've been working on this for a long time now and I cannot figure this out. Can someone help me get this sql statement without erroring or why it doens't work. Here is the SQL statement...
SELECT DISTINCT ItemMaster.ParentNum, ItemMaster.Desc1, ItemMaster.Price FROM BillOfMat AS BillOfMat_1 LEFT JOIN (BillOfMat LEFT JOIN ItemMaster ON BillOfMat.CompNum = ItemMaster.ParentNum) ON BillOfMat_1.CompNum = BillOfMat.ParentNum WHERE (((ItemMaster.ParentNum) Like "200*") AND ((BillOfMat_1.Kw)='25') AND ((BillOfMat_1.Engine)='G') AND ((BillOfMat_1.Fuel)='NL')); ..And here is the error I get. ERROR 1064: You have an error in your SQL syntax near '(BillOfMat LEFT JOIN ItemMaster ON BillOfMat.CompNum = ItemMaster.ParentNum) O' at line 3 Thank you for your help --Mike __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
