Christophe, iso is a column in the subquery and in countries.
so: select distinct * from (select * from Cities where name like 'dusseldorf%' union select * from Staedte where name like 'düsseldorf%') as sub, countries where sub.iso=countries.iso; Regards, Simon 2008/6/24 Christophe Leske <[EMAIL PROTECTED]>: > I think that the column "ISO" is pretty clear here? > > select distinct * from (select * from Cities where name like 'düsseldorf > %' union select * from Staedte where name like 'düsseldorf%'),Countries > where > ISO=countries.iso order by class; > > SQL error: ambiguous column name: ISO > > I mean the ISO from the first selection? This used to work... > > > Can anyone help? > > -- > Christophe Leske > > www.multimedial.de - [EMAIL PROTECTED] > http://www.linkedin.com/in/multimedial > Lessingstr. 5 - 40227 Duesseldorf - Germany > 0211 261 32 12 - 0177 249 70 31 > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users