- Use the Select by Attributes tool before running the Make Feature Layer tool.
- Create a definition query after the join, but before running the Make Feature Layer tool.
-----
Let Feature Class A = The feature class to which the table is joined.
Let Table B = The feature class which is joined to Feature Class A.
1. Establish which joined field (Field B) from Table B forms the basis for the query within the Make Feature Layer tool.
2. Before the join, create a field (Field A) in Feature Class A which is the equivalent to the desired field from Table B.
3. Join Table B to Feature Class A.
4. Set Field A = Field B.
5. Open the Make Feature Layer tool and create the SQL query based on Field A instead of Field B.