I need to create a report from 3 tables. One of the table names will remain the same, but the other 2 table names need to be changed at runtime. They have the exact structure, I just create 2 new tables with different names.

What type of report should I use, SQL, ADORecordSet or what?

I have a working sql query, but it's kind of long.

It's for a web app.