Query Help Merging 2 Tables

Move WHERE condition away from where clause and put it into "ON" clause of your join condition. Simply replace word "WHERE" with "AND". Try and see.