Declare @email nvarchar(30)
set @email = 'arun.dct@gmail.com'


delete from Clientloginaccess 
where ClientLoginId =
(
select ClientLoginId  from   Clientlogin  where email=@email
)


delete from ClientPortalLogonInfo 
where ClientLoginId =
(
select ClientLoginId  from   Clientlogin  where email= @email
)

delete from ClientPortalPhoneNoUpdateLog 
where ClientLoginId =
(
select ClientLoginId  from   Clientlogin  where email= @email
)


delete  from   Clientlogin  where email= @email

go