>I need to create a report that uses information from several different tables. I'm not sure how exactly to do this.

Take a look at views ... you can use views to create a result set for
a report and avoid the need to mess around with hardcoding SQL statements.
Alternatively, hard code a select statement and use the result set for
the report.