hi all

if Exists(select * from sde.Property_Backup p1
where substring(p1.func_key,1,5)='GEOSS'
aND Exists (select p2.Property_ID,p2.Lis_key,p2.Func_key,
p2.Attrib_code
from sde.Property_Backup p2
where p2.func_key = 'PV000000'
And p1.lis_key = p2.lis_key
And P2.aCTIVE =1))
begin

Update sde.Property_Backup p3
set p3.Attrib_code = p12.Attrib_code
where p2.lis_key = p1.lis_key
and substring(p2.func_key,1,5)='GEOSS'
And P1.aCTIVE =1
end

 And i get the Following Error when run it

"Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near 'p3'."

what is wrong


Thanks