I have 2 tables with similar structures. Table1 has fields NAME, ROLE, and STATUS and Table2 has fields GROUP, ROLE and STATUS. The ROLE values for Table1 are from values of GROUP in Table2. I want one query that gives me the combined records where STATUS = "ENABLED". If I do individual table queries, Table1 has 7836 records where STATUS = "ENABLED" and Table2 has 48 records where STATUS = "ENABLED". I would like to see all 7884 of these records in one query result. I created an INNER JOIN Table2 ON Table1.ROLE = Table2.GROUP WHERE Table1.STATUS = "ENABLED" OR Table2.STATUS = "ENABLED" but that only gave me 7849 records. What's the simplest way to get the correct number of records?