Semi-subquery functionality problem
Hi, I am currently programming a module for a popular CMS and this particular system has to run on MySQL 3.23.58 and therefore doesn't support subqueries. What I want to do is:
SELECT count(*)
FROM projects WHERE project_id IN
(SELECT (*) FROM project_images)
AND project_type=1
Since 3.x doesn't support subqueries I have tried all kinds of joins to get this desired result to no avail.
Does anyone have a clue how to do this in 3.x?
Subject
Written By
Posted
Semi-subquery functionality problem
July 01, 2005 02:41PM
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.