Hey So I put together a small test table(s).The question here is, how do I get "Pete" to show by himself, if the change in the value in the columns is unknown?Create Table TestTable(RegID int,FirstName varchar(10),Lastname varchar(10))Insert Into TestTable Values (1, 'Larry', 'Cook')Insert Into TestTable Values(2, 'John' , 'Adams')Insert Into TestTable Values(3, 'Hariett','Conner')Select *From TestTableSelect *Into TestTable_1From TestTableInsert Into TestTable Values(4, 'Paul','Sorbet')Select *From TestTable_1Select Distinct t2.*From TestTable t1Inner Join TestTable_1 t2 ON t2.RegID = t1.RegIDSelect Distinct t2.*From TestTable t1Left Join TestTable_1 t2 ON t2.RegID = t1.RegIDSelect Distinct t2.*From TestTable t1Right Join TestTable_1 t2 ON t2.RegID = t1.RegIDSelect Distinct t2.*From TestTable t1, TestTable_1 t2 WHERE t2.RegID <> t1.RegIDOR t2.FirstName <> t1.FirstNameOR t2.LastName <> t1.LastNameUpdate TestTable_1Set FirstName = 'Pete'WHERE RegID = 4
Everyday life brings me back to reality