[EMAIL PROTECTED] wrote: > 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
In MySQL 4.1 you should find subselects ... not 4.0 -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]