• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Question INNER JOIN THREE TABLES (SSMS 19)

Ardit

New Pleskian
I have these tables as below :

1). Employees table with Column SuperVisorID
2). Departments table with Column name of Departments (....)

3). Supervisor table with Columns : Name, LastName, SupervisorId .

I have edited in TOP 200 ROWS

How to execute correct way on QUERY SQL SERVER 2019 AT PROGRAM AS BELOW TABLES ??
 
SELECT *
FROM table1 AS a
INNER JOIN table2 AS b ON b.id = a.ref_id
INNER JOIN table3 AS c ON c.id = b.ref_id

or

SELECT *
FROM table1 AS a
INNER JOIN table2 AS b ON b.id = a.ref_id
INNER JOIN table3 AS c ON c.id = a.ref_id

etc. where id is a field in the one table that carries the same value that links to the reference field in the other table as ref_id.
 
Back
Top