Simon Davies schrieb: > 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; > Yes, that was it! I was looking for the "as sub" part, i didn´t know how to name my subquery.
Thanks a bunch, -- 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