update ps set PurposeOfVisit=@purposeofvisit, p.IsBanned=@isbanned from [PersonSessions] ps inner join person as p on p.id=ps.visitorid where ps.Id = @id
update ps set PurposeOfVisit='interview', p.IsBanned=false from [PersonSessions] ps inner join person as p on p.id=ps.visitorid where ps.Id = 4
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)