Egor Egorov <[EMAIL PROTECTED]> ha scritto: >You can't do it only with MySQL. Retrieve table names from List table: > SELECT CONCAT("FX", Name) FROM List; > >and then use programming language to construct a query.
Thank you... I've supposed it... What about using UNION? Something like: SELECT * FROM FX5686 UNION SELECT * FROM FX5698 UNION ... WHERE [condition] I obviously need a programming language to compose this query... but it seems clearer to me... if it works! Marco Bresciani -- (o> Utente [EMAIL PROTECTED] da 3,632 anni (2200 unità) //\ Tempo CPU: 2,238 anni (8h 54min 44s medio) V_/_ Posizione: 111701/4900443 (97,72%) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]