I'm trying to access data from two different tables and display them both in the details section of a data report. Can anybody help?

PS I'm using VB6 data report and SQL 7.

Thanks,
Eddie