RDS issue with MSAccess

[mgid]

I'm using RDS to get data from an Access 2000 database.
Here's the code:

<OBJECT CLASSID=&quot;clsid:BD96C556-65A3-11D0-983A-00C04FC29E33&quot;
ID=&quot;dsoMYDSO&quot; WIDTH = &quot;0&quot; HEIGHT=&quot;0&quot; >
<PARAM NAME=&quot;Connect&quot; VALUE= &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MyDataSource&quot;>
<PARAM NAME=&quot;Server&quot; VALUE= &quot;

http://MyServer&quot;>

<PARAM NAME=&quot;SQL&quot; VALUE= &quot;MySQL&quot;>
</OBJECT>

The problem is that when the SQL parameter is a simple select statement against one table it works fine. However, if there are any joins in the sql, no data is returned. I've executed the sql against the database directly and it works fine.

Is this expected behavior?

Thanks for any help.