Re: WHERE IN query

Hi Timothy

That was it! Since I have Version 7.3.2.2.1 the standard form did not work, but yours did.

Thanks

Joerg

>
>As all earlier persons were addressing the fact that it seems you want both
>fields to match may I suggest this instead.
>
>Select * from Table1 where ID||Name in (select ID2||Name2 from Table2)
>
>This may or may not be faster, but from my side of the table it
>is easier to read and almost self-documenting.
>
>Timothy
Received on Fri Apr 23 1999 - 02:01:51 CDT