on 10/3/02 11:20 AM, Ray at ray@l... wrote:

> From a fellow Omnis Developer I think know what you mean from your file
> structure. I think you are going to need a Left Outer Join to get the
> results you want. I don't know if Frontbase allows them or not. Here is what
> the statement looks like in DB2. Translate as needed.
> 
> select transactions.*,FRP_CHQNO,FPR_RECEIPT from TRANSACTIONS LEFT OUTER
> JOIN PAYMENTS ON  (SUBS_INVTYPE='PAY' and FPR_NUMBER=SUBS_REFERENCE_PAID)
> where
> SUB_MEM_NO=<subscriber_no>

Yeah! A fellow Omnis-guy!  <G!>

I think you have hit it - and I also think I've just learned that LEFT OUTER
JOINS may be broken in the most recent version of FB. They are working on it
and may have a fix tomorrow. I had been playing with JOINS (after Jeff's
great description here) but other problems crept in.

I think your ON clause is the piece I've been unable to figure out.

Thanks to all!

=Alan R.