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]