[RESOLU]Column 'c2' in from clause is ambiguous
Bonjour,
L'erreur 1052 : Column 'c2' in from clause is ambiguous s'affiche.
MySQL 5.0.41(je viens d'y passer)
Linux RHEL4 x86_64
requete :
SELECT t1.*
FROM
t1
INNER JOIN t2 USING(c1)
INNER JOIN t3 USING(c2)
INNER JOIN t4 USING(c2)
Je précise que t1 possède aussi un champs C2 et que si j'enlève t1 çà marche et que la requête fonctionne en version 4.1.
Merci d'avance car là je bloque. Je me vois pas repasser toutes les requêtes pour mettre du 'ON' qui lui fonctionne.
Edited 2 time(s). Last edit at 06/19/2007 01:09AM by Bruno LESCALIER.
Subject
Views
Written By
Posted
[RESOLU]Column 'c2' in from clause is ambiguous
5468
June 18, 2007 09:08AM
3063
June 18, 2007 04:06PM
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.