Outer joins; need some assistance
Date: 8 Oct 1994 02:18:06 GMT
Message-ID: <374vgu$spj_at_newstand.syr.edu>
We have a set of two Oracle tables which together make up a group of
transactions for a system. We are attempted to perform the following
SQL
but realize that only one table (either one) may have data in it
fitting the where
clause while the other (again, either one) may not have any data. I've
seen
the Oracle manual where it discusses outer joins, but the example
employs
a one-to-many type scheme. This scenario doesn't follow the example in
the
manual. Any clues how to code the SQL for this type of situation?
( "TOPS"."VREMIT_TRANS"."BATCH_NO" = :as_batch_no ) AND
( "TOPS"."VREMIT_TRANS"."STUB_DTE" = :adt_stb_dte ) AND
( "TOPS"."VREMIT_TRANS"."BATCH_SRC_CD" = :as_batch_src_cd )
Received on Sat Oct 08 1994 - 03:18:06 CET