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

S

seapdesign2020-05-19 07:42:01

SQL

seapdesign, 2020-05-19 07:42:01

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 ?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

smilingcheater, 2020-05-19
@seapdesign

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

Similar questions

V

vladislav9972020-04-22 11:44:26

There is a chat. How to display a list of conversations with the last received or sent message? 2Reply

K

Koal Koalich2018-02-13 15:28:22

Does it make sense to set the ON UPDATE CASCADE constraint when referring to primary keys? 1Reply

E

Eugene2015-10-09 18:10:44

How to append '0' to the left of a string in a query under a certain condition? 1Reply

S

sajgak2011-05-23 20:46:37

An interesting (seemingly simple) SQL query? 5Reply

P

parkito2015-10-11 03:50:33

How to fix an error with the OLE server? 1Reply

Didn't find what you were looking for?

Ask your question