That is one bloody complex query :).
As far as I know, MySQL does not support RIGHT JOIN leyword, so that's where
it's failing. Someone slap me if I'm wrong.
It may be possible to fetch the results you want without such a hairy query.
Just include a partial dump of involved tables and concise desctiption of
what you're trying to select. Otherwise, I don't have guts to look into that
huge query myself! Hopefully someone will! :-P
Sherzod
:
:
: > 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
:
:
:
:
---------------------------------------------------------------------
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
