MySQL Forums
Forum List  »  Oracle

Every derived table must have an alias
Posted by: John Dunn
Date: November 19, 2009 07:47AM

Trying to port the following SQL from Oracle to MYSQL and it gives the error

Every derived table must have an alias

SELECT COUNT(job_id) number_of_jobs FROM
(SELECT distinct(jobs.job_id) FROM active_jobs, jobs
WHERE active_jobs.stage = 'DELETION' AND jobs.deletion_status = 'ERROR' AND jobs.job_id = active_jobs.job_id);

Any idea what the correct syntax is. I need it to run againgst Oracle and MYSQL

Options: ReplyQuote

Written By
Every derived table must have an alias
November 19, 2009 07:47AM
November 19, 2009 10:07AM

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.