Yes it is possible...
Please check the below
update Table_1
set columnTable_1 = @parameter_1
from Table_1 t1
inner join Table_2 t2
on t1.columnTable_1 = t2.columnTable_2
where t2.columnTable_1 = @parameter_2
delete from Table_1
from Table_1 t1
inner join Table_2 t2
on t1.columnTable_1 = t2.columnTable_2
where t2.columnTable_2 = @parameter_1
Sample code......
create type abcd as table
(
id int,
salary int
)
create type nameAbcd as table
(
id int,
name varchar(3)
)
go
declare @p abcd
insert into @p values(1, 100)
insert into @p values(2, 5000)
declare @q nameAbcd
insert into @q values(1, 'abc')
insert into @q values(2, 'xyz')
select * from @p a inner join @q b on a.id = b.id
update @p
set salary = 59
from @p a
inner join @q b
on a.id = b.id
where b.name = 'xyz'
select * from @p a inner join @q b on a.id = b.id
delete from @p
from @p a
inner join @q b
on a.id = b.id
where b.name = 'abc'
select * from @p a inner join @q b on a.id = b.id