Matching records from two tables
I have "table A" that holds clients. "table B" holds items. I want to see if there is a match for a field value. If "value 1A" from table A is < than "value 1B" from table B its considered a match and i like to receive the recordID for both.