Re: [sqlite] Ambigous column

2008-06-24 Thread Christophe Leske
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,

Re: [sqlite] Ambigous column

2008-06-24 Thread Simon Davies
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

[sqlite] Ambigous column

2008-06-24 Thread Christophe Leske
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