MySQL Forums
Forum List  »  French

Re: ERROR 1054 (42S22): Unknown column '*' in 'field list'
Posted by: Jean Molliné
Date: May 13, 2015 02:32PM

Salut,
attention à la casse, dans certaines circonstances, les serveurs SQL peuvent y être sensibles : il faudrait donc tester la requête de la manière suivante :
SELECT softwares.NAME FROM softwares
FULL JOIN devices ON softwares.HARDWARE_ID=devices.HARDWARE_ID;

______________________________________________________________
Une question bien formulée, c'est un problème bien compris : ça représente déjà les 3/4 de la réponse ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1054 (42S22): Unknown column '*' in 'field list'
1100
May 13, 2015 02:32PM


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.