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,
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
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
3 matches
Mail list logo