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