Hi Jason,

>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

HTH,