Edito:
Algo que se acerque puede ser.
Código
SELECT empleados.*, trabajan.IdCargo, trabajan.IdSeccion, trabajan.IdTrab FROM empleados INNER JOIN trabajan ON empleados.IdEmp=trabajan.IdEmp
Encontré esto... a ver si te sirve.
Estructura
Código
mysql> SHOW FIELDS FROM products; +-------------+---------+------+-----+---------+----------------+ | FIELD | TYPE | NULL | KEY | DEFAULT | Extra | +-------------+---------+------+-----+---------+----------------+ | id | INT(11) | NO | PRI | NULL | AUTO_INCREMENT | | category_id | INT(11) | YES | | NULL | | | owner_id | INT(11) | YES | | NULL | | +-------------+---------+------+-----+---------+----------------+ 3 ROWS IN SET (0.01 sec)
Código
mysql> SET @SQL = CONCAT('SELECT ', (SELECT REPLACE(GROUP_CONCAT(COLUMN_NAME), 'id,', '') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'products' AND TABLE_SCHEMA = 'ehn'), ' FROM products'); Query OK, 0 ROWS affected (0.03 sec)
Código
mysql> SELECT @SQL; +----------------------------------------+ | @SQL | +----------------------------------------+ | SELECT category_owner_id FROM products | +----------------------------------------+ 1 ROW IN SET (0.00 sec)
Saludos.