SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (id INT, fkid INT);
CREATE TABLE table2 (id INT);
CREATE TABLE table3 (id INT);
INSERT INTO table1 (id, fkid) VALUES (1, 1);
1 rows affected

INSERT INTO table2 (id) VALUES (1);
1 rows affected

INSERT INTO table3 (id) VALUES (1);
1 rows affected

SELECT * 
FROM   table1
       INNER JOIN table2
       ON table1.fkId = table2.id
       INNER JOIN table3 
       ON table1.fkId = table3.id


id
fkid
id
id


1
1
1
1


SELECT * 
FROM   table1
       INNER JOIN table2
       ON table1.fkId = table2.id,
       table3 
WHERE  table1.fkId = table3.id


id
fkid
id
id


1
1
1
1