Filter on fields in two tables

[goodguy]

I am trying to build a query to pull active records from Table1 filtered on the foreign key for active records in Table2 as below:

 SELECT SALARIES.SALARYID, SALARIES.STAFFID, SALARIES.BASICPAY, SALARIES.ALLOWANCEPAY, SALARIES.OVERTIMEPAY, SALARIES.OTHERPAY, FROM SALARIES INNER JOIN STAFF ON SALARIES.STAFFID = STAFF.STAFFID WHERE STAFF.ACTIVE = TRUE AND SALARIES.ACTIVE = TRUE

The result is a blank recordset as long as the filter on STAFF.ACTIVE is included. Deleting the offending filter results in a populated recordset.

How can I enforce both filters whilst extracting records from one table only?

[ArviLaanemets]

1. The comma after ...SALARIES.OTHERPAY is abyndant! (Probably a typo - otherwise the query would return an error!);
2. Either all values in field STAFF.ACTIVE for persons which have active salaries are FALSE, or values in this field aren't boolean! Include field STAFF.ACTIVE into SELECT clause and remove condition STAFF.ACTIVE = TRUE, run the query, and look at result! What you get in added column?
(Or instead STAFF.ACTIVE include an expression STAFF.ACTIVE = TRUE. Do you get TRUE or FALSE for this expression when the query is run?)

[goodguy]

Thank you and sorry. I fixed a syntax typo, and the query now runs fine.