dbi mysql question

[Dan Muey]

Does any one happen to know if it's possible to do a query within a query :
For instance :
 
This is for demonstartion purposes and is not executable code :
 
prepare $sth ->$dbh...
execute $sth ->$dbh
$sth ->$dbh fetchrowarray {
    $sth2 ->$dbh prepare
    $sth 2->$dbh execute
    $sth 2->$dbh fetchrow array {
        do stuff
    }
    $sth2->$dbh
}
 
$sth ->$dbh finsih
 
in other words do a query then for each row in the query ( IE before the first $sth is 
closed ) do another query ( Different handle $sth2 , because I already know that can 
cause poblems )
 
Thanks
 
Dan