Parametized Select

i've checked a number of places, including the archives, but haven't found any guidance. i have to read data from a sql7 database, as a join. normally, that's not a big deal, but the select (if i could actually write it this way) would look thus:
<pre>
select * from table1, table2, <table3 name>
where table1.id = table2.id and
<table3 name> = table2.table2name
</pre>

that is, a table name is found from another table's column. i know that the database folks do most of their processing using stored procedures, and i'm guessing that this is how they manage to do the select. but i can't find any references that describe the syntax to use.

any guidance is appreciated.

robert young