Jak można takie zapytanie zadać
SELECT `kolumna1` FROM (SELECT `table_title` FROM `tables` WHERE `table_id` = 1 ) WHERE `id` = 100
Bo nie działa Pewnie że po where można dawać drugiego selecta.
SELECT `kolumna1` FROM (SELECT `table_title`,kolumna1,id FROM `tables` WHERE `table_id` = 1 ) tabela WHERE `id` = 100
SELECT `kolumna1` FROM `tables` WHERE `table_id` = 1 AND `id` = 100