我想将两个表合并到一个临时表中,然后在一个查询语句中使用这个临时表。这是我想要创建的临时表的选择语句:
select program, event
from OMEGA.HP
inner join POM.GT
on program = substring(name,7,4)
where LENGTH(name)= 25
什么是创建临时表的最简单方式?
我想将两个表合并到一个临时表中,然后在一个查询语句中使用这个临时表。这是我想要创建的临时表的选择语句:
select program, event
from OMEGA.HP
inner join POM.GT
on program = substring(name,7,4)
where LENGTH(name)= 25
您可以创建一个临时表(您可能希望这样做),但如果您还不知道,我想指出您可以在此查询中创建虚拟临时表。
SELECT *
FROM (
select program, event
from OMEGA.HP
inner join POM.GT on program = substring(name,7,4)
where LENGTH(name)= 25
) AS Virtual_table
你甚至可以像这样加入另一个表格:
SELECT *
FROM (
select program, event
from OMEGA.HP
inner join POM.GT on program = substring(name,7,4)
where LENGTH(name)= 25
) AS v_table74
join (
select program, event
from OMEGA.HP
inner join POM.GT on program = substring(name,2,5)
where LENGTH(name)= 25
) as v_table25 on v_table74.program = v_table25.program
select program, event
into #temp --------------------------------check here
from OMEGA.HP
inner join POM.GT
on program = substring(name,7,4)
where LENGTH(name)= 25
with temptablename(program, event) as (
select program, event
from OMEGA.HP
inner join POM.GT
on program = substring(name,7,4)
where LENGTH(name)= 25
)
select program, event
from temptablename;