table1
id | table

table1 sample data:

1 | 'table2'
2 | 'table3'

table2
id | text

table2 sample data:
1 | 'content from table 2'


table3
id | text

table3 sample data:
2 | 'content from table 3'


What i am trying to do is to select into one step data from table 1 and relating table which is on "table" field on table1.

SELECT `t1`.*, `t2`.`text` FROM `t1` LEFT JOIN `t1`.`table` AS `t2` ON t1.id = t2.id

doesn't work