I have two tables I am comparing a like field on; which must meet specified
valid criteria from a third table. So, if the field meets the criteria, and
the two fields match then return that value.

I would appreciate any help.

Thanks.