the mysql documentation says its possible to use subqueries as the name a table to select from. Although I can't get that to work, what i'm really hoping is possible is to use a value gathered in an outer query as the name of a table in a subquery.

for example i have a table called positions:

ID, FOR_TABLE, FOR_ID
1, articles, 10
2, authors, 20

my articles table:
ID, CONTENT, STATUS
10, BlahBlah, 1

my authors table:
ID, CONTENT, STATUS
20, BlahBlah, 0

basically i'd like to return the status for each row of table 'positions'.

so would i be able to do this...

SELECT * FROM positions LEFT JOIN positions.FOR_TABLE AS t ON positions.FOR_ID = t.ID

?

My problem is actually more complex than this...so i'm taking this step by step. would this work, or is there another syntax i'd need?