Hi Jason, (I hit SEND too fast!!)
>
>>How would I go about selecting multiple fields from different tables where the conditional expression tests fields from different tables?
>
SELECT TableA.Field1, TableA.Field2, TableB.Field1, TableB.Field2 ;
FROM TableA INNER JOIN TableB ;
ON TableA.KeyField = TableB.ForeignKeyField ;
WHERE TableA.Field3 = "TEST" ;
AND TableB.Field4 > 40

HTH,