Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 12:36:41 GMT

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

I have not heard that there is any way to mark a particular record in SQL, you are always working with record set as a whole.

I had to do a similar task, so I do a left outer join of incoming data with the data which is already in the table, for those records which match I bring the value of the field from the target table(it is my right side of the join) to the incoming data (it is left side of my join).

Boris Mogilevsky
Programmer Analyst

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