SQL queries, SELECT statement. how to join three tables and display data?

Hello, help to understand with request.

It is necessary to deduce in request names of students from the specialties "Management", "Economics", and the faculty, but which students. Students arrange into faculties, specialties, names.

STUDENT WITH fields NMZ (primary key) KOD_S, F, I, O, STIP, BALL
NMZ - room transcripts
F - the name of the student
I - the name of the student
O - thestatement
STIP - scholarship
BALL - ball for core exam

Speciality

KOD_S primary key , KOD_F, NAZVANIE_S

KOD_S - specialty code
KOD_F code faculty
NAZVANIE_S - the name of the specialty

FAKULTET

KOD_F primary key
KOD_S - specialty code
NAZVANIE_F - the name of the faculty

Thanks in advance.
August 23rd 19 at 10:50
2 answers
August 23rd 19 at 10:52
INNER JOIN? Should the student still add a new field for communication. Code of specialty or faculty.
SELECT * FROM STUDENT.F as the name of the student
from STUDENT
inner join
Speciality on STUDENT.NMZ = Speciality.KOD_S
how to connect a third table FAKULTET ? - antoinette18 commented on August 23rd 19 at 10:55
fakultet inner join f on f.kod_s = s.kof_s. And Yes, you do have dubbing fields. Do the specialty code of the faculty and connect. - gus_Durgan commented on August 23rd 19 at 10:58
1)can't understand why the table STUDENTS add the field to link if it's there ("NMZ" is the primary key) except through him not to make a bunch of tables?
2)what about the dubbing of the fields in question? - antoinette18 commented on August 23rd 19 at 11:01
August 23rd 19 at 10:54
And why in the specialty code of the faculty, and the faculty specialty code?
Yes that's right. I apologize for the "nobska" questions, learning the basics yourself, a lot of difficulties.... - antoinette18 commented on August 23rd 19 at 10:57

Find more questions by tags SQL