Archives of the TeradataForum

Message Posted: Tue, 27 Nov 2007 @ 18:37:38 GMT

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

Hi,

Try the below statement and see if it serves your purpose. If you can provide the explain plan it would be helpful.

     DELETE FROM employee EDW1
        where (EDW1.employee_id,EDW1.deptt_code ) in
                  (select  EDW2.employee_id,EDW2.deptt_code
                      from   deptt   EDW2
                      where EDW2.deptt <> 'D' );

Thanks

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