Also, this might help to solve the problem, this is a graphical schema of the query from MS Access, to give you all a better idea of what I'm trying to accomplish...
http://www.netsmith.ltd.uk/example.gif ----- Original Message ----- From: "Kevin Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 3:46 PM Subject: SQL Syntax > Hi All, > > Can anyone help me get this query working in MySQL, this was created using > Access, but it doesn't port well for MySQL syntax: > > SELECT basket.id, > products.part_code, > products.product_type, > products.description, > product_options_1.options, > basket.price, basket.quantity, > basket.price*basket.quantity AS total > FROM (products LEFT JOIN product_options ON > products.prod_id=product_options.prod_id) > RIGHT JOIN (product_options AS product_options_1 RIGHT JOIN (basket_header > INNER JOIN basket ON basket_header.basket_id=basket.basket_id) ON > product_options_1.po_id=basket.op_id) ON products.prod_id=basket.prod_id > GROUP BY basket.id, products.part_code, products.product_type, > products.description, product_options_1.options, basket.price, > basket.quantity, basket.price*basket.quantity, basket_header.basket_id, > products.options > HAVING (((basket_header.basket_id)=4)); > > Here is the error message MySQL reports: > > ERROR 1064: You have an error in your SQL syntax near '(product_options AS > product_options_1 RIGHT JOIN (basket_header INNER JOIN baske' at line 9 > > Seems MySQL doesn't like the RIGHT JOIN syntax. Any ideas to the correct > syntax? > > Thanks, > > Kevin > --------------------------------------------------------------------- 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