>>>>>>>>>>>>

SELECT
Table1.ID, Table1.FKID, Table1.MD... some other fields
FROM Table1, Table2 , Table3

WHERE 1 IS NOT NULL
AND (Table2.ID = Table1.FKID)
AND (Table2.FKID = Table3.ID)
AND (Table3.ComputationID = 9)

ORDER BY Table1.ID ASC;


I'd welcome any insight as to what I might be doing wrong.
<<<<<<<<<<<<<

The first thing I would try would be to update your query format. Try:

Select Table1.ID, Table1.FKID, Table1.MD ... other fields
From Table1

Inner Join Table2 on (Table1.FKID = Table2.ID)
Inner Join Table3 on (Table2.FKID = Table3.ID) and (Table3.ComputationID =
9)

Order by Table1.ID ASC/DESC;

HTH

Woody (TMW)