Q&A for speakers of other languages learning English
CREATE TABLE #table1 ( ID int PRIMARY KEY IDENTITY(1,1), firstName nvarchar(50), LastName nvarchar(50), dob date ) create table #test ( id int ) create table #test2 ( id int ) create table #test3 ( id int ) insert into #test values(1) insert into #test2 values(1) insert into #test3 values(1) insert into #table1 values('dim','bar','1994-10-24') select * from #test join #test2 on #test.id = #test2.id join #test3 on #test.id = #test3.id join #table1 on #test.id = #table1.id truncate table #table1 select * from #table1 where id = 1 drop table #test drop table #test2 drop table #test3