help to improve
From: Alexei Fedotov <af_at_ipclearingboard.com>
Date: 20 Feb 2002 06:12:22 -0800
Message-ID: <e6d56cc2.0202200612.3adbcccd_at_posting.google.com>
Date: 20 Feb 2002 06:12:22 -0800
Message-ID: <e6d56cc2.0202200612.3adbcccd_at_posting.google.com>
could you help me to improve the following where clause:
select
...
from ir, gateways, ...
where
...
and (ir.fiGW_src in (select fiGW_id from gateways) or ir.fiGW_src is null)
and ir.fiGW_src = gateways.fiGW_id (+)
Received on Wed Feb 20 2002 - 15:12:22 CET