Re: Replacing Multiple Subqueries

Héctor Villafuerte D. wrote: Hi all, I know how to do this query with subqueries like this: select * from traf_oper where rutasalien in (select ruta_salid from rutas where codigo_ope = 0) and rutaentran in (select ruta_salid from rutas where codigo_ope > 0) --

Replacing Multiple Subqueries

Hi all, I know how to do this query with subqueries like this: select * from traf_oper where rutasalien in (select ruta_salid from rutas where codigo_ope = 0) and rutaentran in (select ruta_salid from rutas where codigo_ope > 0)