select id from school_year where lower(school_year_name) = select
lower(i.enrollment_status) from interns.interns i, interns.student s
where i.unique_key = s.unique_key group by i.id;
produces
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'select lower(i.enrollment_status) from
interns.interns i, interns.student s wher' at line 1
But if I do just this:
select lower(i.enrollment_status) from interns.interns i,
interns.student s where i.unique_key = s.unique_key group by i.id;
It works like a charm!
I just don't get it! This is why I need a DBA!
Phil