Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 10:01:52 GMT

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

I have a query of the below type:

     Delete fac
     FROM UD01_CDW_AGGR_TB.pl_colln_arrmt_fact fac, insert_into_fact del_fac
     Where fac.acct_id = del_fac.acct_id
       AND fac.acct_sfx_num = del_fac.acct_sfx_num
       AND fac.arrmt_made_dt = del_fac.arrmt_made_dt
       AND fac.arrmt_made_tm = del_fac.arrmt_made_tm
       AND fac.arrmt_due_dt  = del_fac.arrmt_due_dt

Although the higlighted join gives me 6500 rows but the delete statement that is operating on the same table deletes only 6300 rows. Any clues to this?

Thanks in advance!

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