Re: help me to improve sql, plz

From: Alexei Fedotov <af_at_ipclearingboard.com>
Date: 12 Mar 2002 00:17:09 -0800
Message-ID: <e6d56cc2.0203120017.4e12b359@posting.google.com>

no aggregations, no functions, consider only these two tables, selecting any fields

select *
from ir, gw
where
(ir.figw in (select fiid from gw) or ir.figw is null) and ir.figw = gw.fiid (+)

it is an outer join but we cannot guarantee the data consistency

damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C742B33.C22B6BBD_at_ci.seattle.wa.us>...
> If you had actually provided some SQL someone could. What is this?
>
> Are you selecting any fields? Doing any aggregations? Using any functions?
> Linking an unending list of tables? Connecting the tables via what fields?
>
> Daniel Morgan
>
>
>
> Alexei Fedotov wrote:
>
> > could you help me to improve sql
> >
> > select
> > ...
> > from ir, gw, ...
> > where
> > ...
> > and (ir.figw_src in (select figw_id from gw) or ir.figw_src is null)
> > and ir.figw_src = gw.figw_id (+)
Received on Tue Mar 12 2002 - 02:17:09 CST