How to use id to find the username in another table?

Question

SQL

There are 2 tables: card and visits .
How can I make a query so that using the id in the visits table I get the username from the card table ?

Answer 1

Read about the JOIN operator in the DBMS you are using (which is not listed in your question).
Write a query using it.