R
R
reboot7772019-06-22 15:26:36
SQL
reboot777, 2019-06-22 15:26:36

Communication between the main table and additional?

Hello.
How the tables are linked, if interested in how to link the tables correctly.
1. The main table is People, where the columns are: id, full name, id_treatment.
2. Table - Treatment, where the columns are id_chelovek, Date of treatment Reason for treatment, Mark of completion.
3. The goal is - the ability to link to one person an unlimited number of records in the Treatment tables.
Ivanov Ivan Ivanovich
Appeal - 1
Appeal - 2
Appeal - 3
And so on.
PS if possible, visually, graphically.
Thank you for your attention.
I admit it's a stupid question.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Lazy @BojackHorseman, 2019-06-22
@reboot777

Join (SQL)

SELECT *
FROM `people`
JOIN `treatment` ON `people`.id = `treatment`.`id_chelovek`

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question