How to add an SQL to report?

[rpillc]

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 Crystal’s 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,

Steve

[dilemma]

Is 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

[rpillc]

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

Steve