The first works fine,
thank you very much.
 
Rik

-----Oorspronkelijk bericht-----
Van: news@... [mailto:news@...]Namens Svein Erling
Tysvær
Verzonden: donderdag 19 juli 2001 15:23
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] query problem

>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/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]