Archives of the TeradataForum

Message Posted: Wed, 04 Jan 2012 @ 10:12:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Unless I'm missing something obvious, how about:

     Delete from tablea
     where columna = tableb.columna
        and tableb.flag = 'd'
     ; Insert into tablea
     Select ...
     from TableB
     where flag = 'I';

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>