Well the first thing I'll say is that you are not going to be running a report off of the whole table. Secondly, you will have indexes that make this a lot faster. I would assume that you will have an index on at least all of the join terms. If you can also have a covering index on the returned values then you can minimise the number of bookmarks you create in the execution plan.
Those tables are not really very big for SQL to handle, the key thing is the indexing you have and the way you join the tables. I hope for example that the keys are all integers or unique at least.