Hello there i have created three department tables Departments Supervisor I have filled them with notes how to execute this

Question

INNER JOIN THREE TABLES SQL SERVER 2019

Answer 1

Uhh what columns does each table have?

Answer 2

A͢J - S͟o͟l͟o͟H͟e͟l͟p͟e͟r͟'s solution might be the one you're looking for unless you didn't declare any foreign key or some sort

Answer 3

Ardit Emerllahu

That's SQL server syntax before dislike you should check on Google.

Answer 4

Ardit Emerllahu

You don't think Supervisor table missing one more column which should be use for JOIN with another table?

Answer 5

SYNTAX??

Answer 6

SELECT * FROM table t1
INNER JOIN table t2 ON t1.id = t2.id
INNER JOIN table t3 ON t1.id = t3.id
WHERE your_condition

I assumed there is column id in all 3 tables

Answer 7

SQL SERVER 2019 SYNTAX I MEAN

Answer 8

I have created three tables to connect to the INNER JOIN Command AS BELOW

DEPARTMENTS TABLE DEPARTMENT TABLE SUPERVISOR TABLE

The Departments table contains the following columns: DepartmentiID, Name, Surname.

The Department table contains the following columns: DepartmentsID, personal number, first name, last name, #NumberDay, using COUNT.

The SuperVisor tables are the following columns: SupervisorID, FirstName, LastName .

Answer 9

there has to be a column like departments_id in department that link's between the 3 table's so that you can make on condition comes true.

make an id_departments or department in supervisor table or table contains them all. based on you data relation if 1-1 or 1-to more