Table selection

Hello all, I have a little problem to solve. I have a List table that lists the tables contained in the same DB. This table has a Name filed that contains such names. My problem is that the list.name filed doesn't contain the complete name of the tables but it misses a prestring. Say: a table

Re: Table selection

Marco Bresciani [EMAIL PROTECTED] wrote: Hello all, I have a little problem to solve. I have a List table that lists the tables contained in the same DB. This table has a Name filed that contains such names. My problem is that the list.name filed doesn't contain the complete name of the

Re: Table selection

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 *

Re: Table selection

Marco Bresciani [EMAIL PROTECTED] wrote: 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