Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 13:04:56 GMT


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

Subj:		Re: Issue in delete

From:		Victor Sokovin

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?

Nothing strange so far if the join is not one-to-one.

Regards,

Victor