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
Subject
Written By
Posted
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.