[suggestion] Support for WHERE on joined tables

Suggestion for using a WHERE clause on the table that's being joined.