You can't use brackets on left joins like that. If you want to do two left joins, you use: LEFT JOIN table1 ON conds LEFT JOIN table2 ON conds That's why you're getting the error that mysql displayed, it doesn't expect a bracket.
Chris >>>>>>>>>>>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')); --------------------------------------------------------------------- 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
