1.
create procedure DeleteEntry
as
delete a from products1 a
inner join products b on a.productname=b.productname
go
try this i have tested.
[Edit]
2.
(Added from another answer box)
alter procedure DeleteEntry
as
begin
delete a from products1 a
inner join products b on a.productname=b.productname
end
select * from products1
go
now try this..
[/Edit]