really need help with this
Posted by: joewaster
Date: May 18, 2005 12:10PM

SELECT SUM(minimum) 'minimum'

FROM ( (SELECT cmin * 1 'minimum' FROM book WHERE ID=4 )

UNION ALL (SELECT cmin * 2 'minimum' FROM book WHERE ID=5)) as s


when you run this query on 4.1.8 it returns
"Every derived table must have its own alias" error
, while newer version of mysql seems to work

is there a quick fix i can do to this query to get it working,

because i can't just upgrade to a newer mysql right away

please help

Options: ReplyQuote

Written By
really need help with this
May 18, 2005 12:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.