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 su

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: SEL

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 n

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 ta