>Anyone an idea ?

Sure,

the way you've specified your query it should only return one au_verzekering,
but it returns several. You could change your code to using IN rather than =,
but I rather suggest
select * from verz
where exists (
select 1 from aut_
where au_makelaar = '0000' and
au_verzekering=verz.v_code)

or

select distinct verz.* from verz
join aut_
on au_verzekering = v_code
where au_makelaar = '0000'

I'd go for the latter solution if it gives you the desired results - probably
faster and more intuitive.

Set

Rik wrote:

> Hi list,
>
> my query give me always the message : multiple row in singleton select.
>
> select * from verz where (v_code =
> (select distinct au_verzekering from aut_ where au_makelaar = '0000'))
>
> for update
>
> Anyone an idea ?
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/