Need Oracle -> mySQL query translation, please

[ppowell]

Here is my Oracle code:

Ok I finally figured out the query I want to write, here is the Oracle version of the query:

select i.enrollment_year, (select p.allowed from permissions p, partners q, intern_complete_application a where p.intern_id = a.intern_id and p.intern_id = 821 and p.partner_id = q.partner_id and upper(q.partner_name) = 'ECSU' and upper(a.has_ecsu_essay) = 'Y') as allowed, ica.*
from interns i, intern_complate_application ica
where i.intern_id = ica.intern_id
and i.intern_id = 821;

I hope that clears things up a bit.

Phil

PS: I am using mySQL v3.23 PHP 4.2.0 and Linux Red Hat v.?

[LordShryku]

Your Oracle query contains a sub-query, which MySQL does not support in your version.

[ppowell]

I know, I read the mySQL manual where subqueries cannot be done in my version, and so i could not think of a logical way of doing this particular query then in mySQL.. and switching to Oracle is beyond "not an option" at this time.

Phil