Sub Query question

[Daniel Rossi]

Hi there, I was wondering if its possible to be able to send a field 
from the outer table to be used as the where statement for the sub 
query ?

something like this
select somefield from table 1, (select count(*) from table2 inner join 
table1 using somekey where table1.key=somefield) as alias

where somefield is in the outer table
what i was also hoping to achieve was something like this
select somefield from table 1, (select field2 from table2 inner join 
table1 using somekey where table1.key=somefield) as alias

and alias would contain rows of a one to many resulset ???? :| that 
would be cool , so then i can list in a datagrid without having to do a 
nested loop !

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]