SQL Server 2019

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

create table a (id int, foo int);
create table b (id int, foo int);
create table c (id int);
create table d (id int);
insert into a values (1,1),(2,2),(3,3);
insert into b values (1,1),(2,2),(3,3);
insert into c values (10),(20);
insert into d values (1),(2);
10 rows affected

select * from a join b on a.id = b.id       ,     c join d on d.id = a.id ;
Msg 4104 Level 16 State 1 Line 1
The multi-part identifier "a.id" could not be bound.

select * from a join b on a.id = b.id  cross join  c join d on d.id = a.id ;


id
foo
id
foo
id
id


1
1
1
1
10
1

1
1
1
1
20
1

2
2
2
2
10
2

2
2
2
2
20
2