How in MSSQL to bind to 1 id-shnik 2 values ​​located in the same column, but on different lines?

Question

SQL

In general, it is necessary that when choosing 1 person under a certain ID, its location is determined, but there can be several locations and they must be somehow connected, how can this be implemented?

Answer 1

all you just do is
go for any textbook on skul, read it, apply the knowledge
your question lies in the 1 to many connection, good luck with your study.

Answer 2

Separate table with fields like id, person id, and location.