No conozco alguna instrucción que haga eso, me temo que tendrás que indicarlas.
Edito:
Algo que se acerque puede ser.
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
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)
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)
mysql> SELECT @SQL;
+----------------------------------------+
| @SQL |
+----------------------------------------+
| SELECT category_owner_id FROM products |
+----------------------------------------+
1 ROW IN SET (0.00 sec)
Saludos.