query (sub) select

Hey guys, I was wondering if this code is possible. I say it is a 4GL code that I am migrating to PHP. +++++++++++++++++++++++++++++++++++++++++++ $side1Query=ifx_query('select * from line, event' .' where line.e_id=event.e_id ' .' and l_type="'.$s_lt.'" ' .' and l_status in ("O","C") ' .' and u_type="P" ' .' and betno in (select min(betno) from line, event where line.e_id=event.e_id and l_type="'.$s_lt.'") ',$db) or die (ifx_error()); +++++++++++++++++++++++++++++++++++++++++++ I am asking because it would greatly help me since my current method is to select the (min) then use the min in the query. +++++++++++++++++++++++++++++++++++++++++++ $minS_LT = ifx_query('select min(betno) from line, event' .' where line.e_id="'.$ecols['e_id'].'" ' .' and line.l_status in ("O","C") ' .' and line.u_type="P" ' .' and l_type="'.$s_lt.'" ',$db) or die (ifx_error()); $betcols1=ifx_fetch_row($minS_LT); $min_betno1=min($betcols1); +++++++++++++++++++++++++++++++++++++++++++ $side1Query=ifx_query('select * from line, event' .' where line.e_id=event.e_id ' .' and l_type="'.$s_lt.'" ' .' and l_status in ("O","C") ' .' and u_type="P" ' .' and betno="'.$min_betno1.'"',$db) or die (ifx_error()); +++++++++++++++++++++++++++++++++++++++++++ Thanks in advance for your assistance. Regards, RedHat http://redhat.opensource.bz redhat@opensource.bz