On SQL Server 2000 I have the following table : 

   create table person (id int not null, PRIMARY KEY CLUSTERED (id)).


On Sybase 12.5.1 I have an other table named naw which contains over 4 million rows. It's primary key is defined as naw_id int not null.

Now I want to start a query from SQL Server which gives me all the rows of naw that matches naw_id = persoon.id (prox. 1000 rows). Therefor I created an linked server SYB_SHADOW to my Sybase server with the OLE DB Driver for ODBC from Microsoft.  

I succeeded in querying the Sybase data from SQL Server but I'm looking for a method which joins both tables using an index scan on table naw.

Is this possible? This is my query:

set ansi_nulls on
set ansi_warnings on
go

select * from persoon inner join openquery (SYB_SCHADOW, 'select naw_id from naw') AS N on persoon.naw_id = N.naw_id
go