How to add an SQL to report?

I am using Crystal Reports 9.0.

I would like to link to tables together with fields "unitID" and "PropUnit"

I links the fields but when I add more then one field to the report the data disappears in the preview.

I looked at Crystals sample report. It uses a SQL statement.

How do I add an SQL statement if that's what I need to get this to work.

Thanks,

SteveIs it possible that there are no records satisfying this criteria/join ?

I don't think displaying 3 fields would suppress display of records from preview!

Thanks|||Thanks. This is my 1st try at using CR and that didn't even cross my mine.

Steve