Aljosa,

Yes I tried, but it didn't give me any advantages for speed. The
Subselect query from Set was faster.

Thanks,

Nico Callewaert
-----Oorspronkelijk bericht-----
Van: Aljosa Turk [mailto:ista@...]
Verzonden: woensdag 4 april 2001 11:05
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: To SET [IBO] Slow query question


Did you trie with inner join?

SELECT A.DealerNo, A.Country, B.Name
FROM Dealer A
INNER JOIN Country B ON B.Code = A.Country
WHERE A.DealerNo = 123456

HTH, Aljosa

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, April 04, 2001 10:39 AM
Subject: RE: To SET [IBO] Slow query question


> Yes, I think IBO requires a fieldname. Try
>
> SELECT A.DealerNo, A.Country,
> (SELECT B.Name FROM Country B WHERE B.Code = A.Country) as Name
> FROM Dealer A
> WHERE A.DealerNo = 123456
>
> Set
>
> At 10:24 04.04.2001 +0200, you wrote:
> >Hi Set,
> >
> > One more question. I only tested this code below in
IBConsole.
> >It is working well. If I paste this code in a TIB_Query component, I
have
> >a error message 'Fieldname : not found'.
>
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>


Yahoo! Groups Sponsor

Click Here to Find Software Faster


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



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