0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited oct 21 17 anonymous

created feb 9 12 aF