On Sat 2003-02-01 at 10:35:46 -0000, [EMAIL PROTECTED] wrote:
> Hi Benjamin,
>
> Wow, that sure sorted that problem out... I had to rejig it slightly to
> get it to work,
Oops... too much copy&paste by me :-)
> but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
>
> SELECT
> b.id,
> p.part_code, p.product_type, p.description,
> po.options,
> b.price, b.quantity,
> b.price*b.quantity AS total
> FROM basket_header bh
> INNER JOIN basket b ON b.basket_id = bh.basket_id
> LEFT JOIN products p ON p.prod_id = b.prod_id
> LEFT JOIN product_options po ON po.po_id = b.op_id
> WHERE bh.basket_id = 4
> GROUP BY b.id, p.part_code, p.product_type, p.description, po.options,
> b.price, b.quantity, total, bh.basket_id, p.options
>
> Many thanks, now I'll work out why I couldn't do that so I can better
> understand it.
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
