clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335968 fiddles created (27479 in the last week).

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
 hidden batch(es)


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.
 hidden batch(es)


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
 hidden batch(es)