Re: cf in select stmt help -Works - THANKS

2001-08-21 Thread Amanda Stern
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

RE: Cf in Select Stmt help

2001-08-21 Thread Bill King
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

RE: Cf in Select Stmt help

2001-08-21 Thread Kevin Gilchrist
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

RE: Cf in Select Stmt help

2001-08-21 Thread Rice, John J
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