You can't do that query... either both tables are very similar in structure and you want to show the results as if they were only one table, or those tables have some kind of relationship using primary and foreign keys
I think that you're in the first case and that means using a UNION
I suggest that you don't use the wild card (*) and take a bit of more time to write the name of the fields you need. It improves speed.
I guess that both table have a field named "email". Because the name of the field is not exactly the same in both tables (a pratice that I follow, I never use the exact same name in two tables) you'll need an alias.
SELECT users_email AS email FROM table_users
SELECT members_email AS email FROM table_members
email LIKE '%s'
I wrote [ALL] beause this is optional. The default behaviour of a UNION is to select all the records in the table, anyway.
Because you're using patterns, you need to use LIKE and not = when you write your WHERE clause
This should work