Is it possible to write a SELECT statement with just sub-selects? I don't need a FROM for a query I am writing.
E.g.
SELECT
(SELECT count(job.job_number) FROM job, job_status_log WHERE job.job_number = job_status_log.job_number AND job.job_log_number = job_status_log.job_log_number AND job.job_status_flag = 'C' AND job_status_log.status_code IN ('J020', 'J020', 'J040')) as Orders_Issued_Awaiting_Completion
So, why is this a nested select? Just select your count. Also, you should really use the LEFT JOIN, INNER JOIN syntax instead of joining in the where clause.
A SELECT statement with just sub-selects?
Posted - 11/06/2012 : 05:49:33
