Posted by Serge Rielau on 04/12/06 22:23

select * into #tmp_table
from products p
left join
sales s on p.p_data = s.p_data
where s.p_data IS NOT NULL OR
@condition <> 0
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

• Next in forum: Re: insert into temp table based on if condition
• Prev in forum: Re: SQL Query Question
• Thread view: Re: insert into temp table based on if condition

[Reply to this message]