have two tables:
ReservationName

 +-------+-------+-------+-------+ | Name | +-------+-------+-------+-------+ | Brad Pitt | | Morgan Freeman | | Bobby deniro | +-------+-------+-------+-------+ 

BookingDetails

 +-------+-------+-------+-------+ | Name | ID |Eid | +-------+-------+-------+-------+ | Brad Pitt | 1 | ab123 | | Morgan Freeman | 2 | pq123 | | Bobby deniro | 3 | rs123 | +-------+-------+-------+-------+ 

I have to match the names in ReservationName with BookingDetails . If they are same (count and value) .

Above example of mine should return true as names are identical and count is 3. The aforementioned condition is part of If exists logic that I am using in sp.

I have two tables:

ReservationName

 +-------+-------+-------+-------+ | Name | +-------+-------+-------+-------+ | Brad Pitt | | Morgan Freeman | | Bobby deniro | +-------+-------+-------+-------+ 

BookingDetails

 +-------+-------+-------+-------+ | Name | ID | Eid | +-------+-------+-------+-------+ | Brad Pitt | 1 | ab123 | | Morgan Freeman | 2 | pq123 | | Bobby deniro | 3 | rs123 | +-------+-------+-------+-------+ 

I have to match the names in ReservationName with BookingDetails .

If they are same (count and value) .

Above example of mine should return true as names are identical and count is 3. The aforementioned condition is part of If exists logic that I am using in a stored procedure.

have two tables: ReservationName

+-------+-------+-------+-------+
| Name |
+-------+-------+-------+-------+
| Brad Pitt |
| Morgan Freeman |
| Bobby deniro |
+-------+-------+-------+-------+ BookingDetails +-------+-------+-------+-------+
| Name | ID |Eid |
+-------+-------+-------+-------+
| Brad Pitt | 1 | ab123 |
| Morgan Freeman | 2 | pq123 |
| Bobby deniro | 3 | rs123 |
+-------+-------+-------+-------+

Above example of mine should return true as names are identical and count is 3. The aforementioned condition is part of If exists logic that I am using in sp.

I am using Sql server

Thanks in advance.

have two tables: 
ReservationName

 +-------+-------+-------+-------+ | Name | +-------+-------+-------+-------+ | Brad Pitt | | Morgan Freeman | | Bobby deniro | +-------+-------+-------+-------+ 

BookingDetails

 +-------+-------+-------+-------+ | Name | ID |Eid | +-------+-------+-------+-------+ | Brad Pitt | 1 | ab123 | | Morgan Freeman | 2 | pq123 | | Bobby deniro | 3 | rs123 | +-------+-------+-------+-------+ 

Above example of mine should return true as names are identical and count is 3. The aforementioned condition is part of If exists logic that I am using in sp.