Teemu Kuulasmaa <[EMAIL PROTECTED]> wrote:
>
> I was wondering is it possible to use "SHOW COLUMNS FROM tbl_name" as a
> subquery.
>
> I tried something like this ( w/o success ):
>
> SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID
> =t2.field;
>
> or
>
> SELECT fiel
Hi all,
I was wondering is it possible to use "SHOW COLUMNS FROM tbl_name" as a
subquery.
I tried something like this ( w/o success ):
SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID
=t2.field;
or
SELECT field FROM (show columns from Research.idefix);
Teemu
--
My