According to documentation, in MySQL version 4.0, it is possible to use sub-selects, but i haven't found the correct syntax... Does any one know how to do this? I need someting like this:
Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
