Outer join

From: vidas <vidasm_at_yahoo.com>
Date: 20 Jun 2001 07:15:23 -0700
Message-ID: <cdbd2dd.0106200615.761033b3_at_posting.google.com>

I have a question about outer-join. I have such kind of query:

Select t1.sdate, t1.acop, t1.bcop, t1.min, t2.price from store t1, invsell t2
where

t1.acop =t2.opname and
t1.codadest (+) =t2.destname and
t1.cod (+) =t2.type and
t2.validdate =

(select max(validdate) from invsell t4
where

t2.opname=t4.opname and 
t2.destname=t4.destname and
t2.networktype=t4.type and
t4.validdate < t1.sdate)

I would like to have all rows from the table store and matched from invsell. Some suggestions? Received on Wed Jun 20 2001 - 16:15:23 CEST