I have to tables  

vendor

ap

I have linked them up in database link  on a key field vendor-num  and said the vendor table is an outer join

In the report in the Select Expert:  I have another requirement to state that AP record the field balance <> 0

Now Does crystal first do the outer join and get all the records.

Then it goes to the Select Expert and filters out more?

I wanted all the vendor records and and only those AP records with balance not 0.  If no AP records for that vendor I still wanted the vendor record

It seems if AP record with balance of 0,  the associated vendor record does not get selected.


A bit confused here

Any help is appreciated

thanks  and if the record doesn't even exit  then yu don't get anything back?

actually i need all the vendor records  and any record in the accounts payable file.   It seems  if I put something in the select expert that has to do with ap  and doesn't match the selection  no record is selected even though   i want the vendor record  I think I have to put it into an sql  and run the sql instead

I wanted a true outer join everything in  table a  and records in table b if they exist and match the requirement