----- Original Message ----- > From: "Javier Yévenez" <jyeve...@gmail.com> > > If the field db1.table1.field1 has the same name that the field > db2.table1.field1, maybe you have to use an alias for each table:
No, he's using a subquery, those fields cannot be referenced. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org