The Where clause executes after the Inner join (so all records in both tables are inner joined first) then the Where clause reduces the records selected. Move the IN ()...
In Foxpro the field width includes the decimals, the minus sign and the decimal place('.'). So a number field like -9999.99 needs to be set up as N(8, 2). DTS...
I believe OPENROWSET works without linking the databases, as long as the PC you are running the query on can see the other server on the network. I may be...
You can use openrowset() to return a something (I am not sure what) that can be included in a select statement as if it were a table in your current...
I'm no expert but it looks like the connection timeout has been reached (or maybe just the query timeout). Increase the timeouts on the servers concerned (sorry, I don't know...