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 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

RE: Cf in Select Stmt help

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 where cats.iCasacApptID

RE: Cf in Select Stmt help

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?

Re: cf in select stmt help -Works - THANKS

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 query. My