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


Subject
Views
Written By
Posted
Every derived table must have an alias
8519
November 19, 2009 07:47AM
3605
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.