I have a database that has some tables linked together with a foreign key. How would I write the stored procedure to to create a report? Do I need multiple queries to get the data from the multiple tables? Any tips would be helpful.

Thanks