• select *

    from tableA a

    where exists (select * from tableB b where a.ID00 = b.ID00 and a.OBJECT00 = b.OBJECT00 and a.FIELD00 = b.FIELD00)

    BTW, your sample data isn't really helpful. When you post requests, please provide create table statements, inserts to populate the tables and then expected output. That way we can write a statement and validate it actually does what it needs to do instead of guessing. 🙂

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service