OK, probably a dumb question but I'm fairly new to getting into this.  Am building a report pulling from two tables (A & B) and one view table (View).  Basic  info:

• Table A has a field in common with View
• Table A has a field in common with Table B
• Table B and View have NO fields in common

Results I'm getting are duplicates of each record showing, one obviously from the Table A and the second from View

The results I want is only the results with data from View

How can I get this?  I've tried changing the to/from direction of the links, changing the SQL Join Type, but still getting duplicate records showing, the one I don't want have a bit less data showing for that record.

Oh, the version of Crystal which this application packages with it is Crystal Reports 7.0.1.200

This is driving me nuts so hopefully someone can help me quickly.

Thanks!