Posted by: U?Me May 29, 2008
Login in to Rate this Post:
0 
? 
?
But the where condition is insufficient. UPDATE LiveTableA takes into consideration Table1 and Table2
from
LiveTableA a--------------------------------------------1.
left outer join ..Table1..on-------------------------------2.
left outer join ..Table2..on--------------------------------3.
where
a.ExpDate between DATEADD(dd,30,getdate()) and DATEADD(dd,37,getdate()) ------Table A (1)condition
-------
and Table1.codeColumn in ( 'ABC', 'XYZ') ----------------------Table1 (2) condition
)
from
LiveTableA a--------------------------------------------1.
left outer join ..Table1..on-------------------------------2.
left outer join ..Table2..on--------------------------------3.
where
a.ExpDate between DATEADD(dd,30,getdate()) and DATEADD(dd,37,getdate()) ------Table A (1)condition
-------
and Table1.codeColumn in ( 'ABC', 'XYZ') ----------------------Table1 (2) condition
)