Check all users from table 1 if one or more exist in table 2

[hasexxl1988]

Hello,

is it possible to check directly via the database whether an entry from table 1 'Users' is also present in table 2 'Users'? Quasi a like function where it checks all 'Users' from table 1 with the 'Users' in table 2 and outputs whether the user already exists in table 2.

Check all users from table 1 if one or more exist in table 2.

Thanks for the help

[hasexxl1988]

I rephrase the question, it was described incorrectly:

A database with 2 tables. User1 and User2. Is it possible to check which user from User1 is also present in User2?

[Nobbie]

Select Distinct User1.Users From User1, User2 Where User1.Users = User2.Users

[hasexxl1988]

Select Distinct User1.Users From User1, User2 Where User1.Users = User2.Users

THANKS