I recently read that MySQL does not support sub-queries. I have an sql statement that needs a subquery. Is another way to write the query that would work correctly with MySQL? ( I would really like to have it in one single query instead of two separate queries).
Query with Sub-Query in it
SELECT relMonumentID, DivisionID from location t1, county t2 WHERE t1.relCountyID = t2.CountyID and DivisionID=(SELECT DivisionID from location t1, county t2 WHERE t1.relMonumentID = '369' and t1.relCountyID = t2.CountyID) ORDER BY relMonumentID asc
Query with Sub-Query in it
SELECT relMonumentID, DivisionID from location t1, county t2 WHERE t1.relCountyID = t2.CountyID and DivisionID=(SELECT DivisionID from location t1, county t2 WHERE t1.relMonumentID = '369' and t1.relCountyID = t2.CountyID) ORDER BY relMonumentID asc