search mutliple table fields with one field from another table

[jesushax]

what im tryign to do is

 

say table 1 has the number 35 in the DOG Field and only has one row

 

then in table 2 has many numbers from 1-100 in multiple rows but still in the CAT field

 

how would i be able to use dog field to search and find an equal in the CAT field

 

so

 

table 1

Column DOG

Row 35

 

table 2

Column CAT

Row 12

Row 29

Row 87

Row 32

Row 13

Row 35

 

i want to compare whats in table 1 DOG to all the Values in table 2 CAT then if one matches dispay some text

 

Thanks for any help