MySQL Forums
Forum List  »  Oracle

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

OK I solved this by adding an alias at the end :

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) myalias;

Options: ReplyQuote

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