Thank you!!
That did the trick.
--- Deanna Schneider <[EMAIL PROTECTED]>
wrote:
> Whew! This is an interesting query, Amanda.
>
> There are a couple of issues here. Your loop should
> be outside the query,
> otherwise what you'll end up with is multiple select
> statements within the
> qu
Sounds like a "LEFT Join" is in order.
- BILL -
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 1:16 PM
To: CF-Talk
Subject: Cf in Select Stmt help
Hello,
I am trying to get this query to work and not sure
how...anyone have any ideas? T
c. etc.
-Original Message-
From: Rice, John J [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 4:15 PM
To: CF-Talk
Subject: RE: Cf in Select Stmt help
if you are using Oracle use this type of syntax:
AND cas.iCasacApptID = cats.iCasacApptID(+)
The (+) makes an outer join
if you are using Oracle use this type of syntax:
AND cas.iCasacApptID = cats.iCasacApptID(+)
The (+) makes an outer join where cats.iCasacApptID may or may
not have a match for cas.iCasacApptID. So all records from cas
will come back. A null will be in the cats column where
there was not a m
4 matches
Mail list logo