Re: update query...

[William Chiquito]

Hi Dan,

Try:

update table_name a
	inner join table_name b on a.newid = b.newid and a.rp = b.patid
	inner join table_name c on b.rp = c.rp
set c.gar = b.newid;

Edited 1 time(s). Last edit at 02/24/2008 10:38PM by William Chiquito.