Subquery ( show columns from...)

[Teemu Kuulasmaa]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]