Hi, in the simplified query below, is there a wildcard I can use to pull ALL "ID"? In the attached example, this query will pull all IDs if the value in Table2.Group is A. How do I make the query return all IDs for both group A and group B without having to list both A, B in the Table2.Group column? Thanks.
FROM Table1 INNER JOIN Table2 ON Table1.Group = Table2.Group;