See
for some tips
Dan
8/23/06, spacemarc <spacemarc (AT) gmail (DOT) comwrote:
Hi,
I have a query like this:
SELECT table1.*,(
SELECT ****( field2 )
FRM table2
WHERE id=10
) AS total
FRM table1
GRUP BY id
LIMIT 1
but the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks