MySQL Forums
Forum List  »  French

ERROR 1054 (42S22): Unknown column '*' in 'field list'
Posted by: toto titi
Date: May 13, 2015 10:07AM

Bonjour à tous,

Je m'excuse d'avance je suis loin d'être un expert en SQL, mais alors là je ne comprends pas..

Je cherche à réaliser une requête SELECT sur mon serveur OCS Inventory via une jointure. Je ne parviens pas à comprendre l'erreur que me renvoi MySQL :

ERROR 1054 (42S22): Unknown column 'softwares.name' in 'field list'

Ci-dessous les informations des tables et ma requête :


________________________

mysql> SELECT softwares.name FROM softwares
    -> FULL JOIN devices ON SOFTWARES.HARDWARE_ID=DEVICES.HARDWARE_ID;
ERROR 1054 (42S22): Unknown column 'softwares.name' in 'field list'
mysql> desc softwares;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ID          | int(11)      | NO   | PRI | NULL    | auto_increment |
| HARDWARE_ID | int(11)      | NO   | PRI | NULL    |                |
| PUBLISHER   | varchar(255) | YES  |     | NULL    |                |
| NAME        | varchar(255) | YES  | MUL | NULL    |                |
| VERSION     | varchar(255) | YES  | MUL | NULL    |                |
| FOLDER      | text         | YES  |     | NULL    |                |
| COMMENTS    | text         | YES  |     | NULL    |                |
| FILENAME    | varchar(255) | YES  |     | NULL    |                |
| FILESIZE    | int(11)      | YES  |     | 0       |                |
| SOURCE      | int(11)      | YES  |     | NULL    |                |
| GUID        | varchar(255) | YES  |     | NULL    |                |
| LANGUAGE    | varchar(255) | YES  |     | NULL    |                |
| INSTALLDATE | datetime     | YES  |     | NULL    |                |
| BITSWIDTH   | int(11)      | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)

mysql> desc devices;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| HARDWARE_ID | int(11)      | NO   | MUL | NULL    |       |
| NAME        | varchar(50)  | NO   | MUL | NULL    |       |
| IVALUE      | int(11)      | YES  | MUL | NULL    |       |
| TVALUE      | varchar(255) | YES  | MUL | NULL    |       |
| COMMENTS    | text         | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

En espérant que quelqu'un pourra me venir en aide. Merci.

Cordialement.

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1054 (42S22): Unknown column '*' in 'field list'
3071
May 13, 2015 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.