I have tableA with thousands of records.
I have tableB with just a few records.
I need to grab a WHOLE record in tableB and and search for that WHOLE record in tableA.

Is there an easy way to search for a WHOLE record in another table? Each record has 70+ fields.

Any comments will be welcome. Thank you in advance.