0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

create table #test (
id int
)

create table #test2 (
mid int,
value date,
feld text
)

insert into #test values(1)
insert into #test values(2)
insert into #test values(3)
insert into #test2 values(1, getdate(), 'hans')
insert into #test2 values(2, getdate(), 'peter')

select * from #test
inner join #test2 on #test.id = #test2.mid

drop table #test
drop table #test2

fork query

edited aug 14 18 anonymous

created feb 9 12 aF