Re: trouble with join and nested query

[laptop alias]

Some CREATE and INSERT statements would have been nice :-)

SELECT c.cartid, c.size, SUM( c.quantity ) , pl.price, pl.price * SUM( c.quantity )
FROM cart c
LEFT JOIN price_list pl ON pl.size = c.size
LEFT JOIN temp t ON t.cartid = c.cartid
WHERE t.login = 'abc'
GROUP BY c.cartid, c.size
LIMIT 0 , 30