i have gave a alias name of table

how can i merge the two table in update query?

hi friend

thanks for reply

i got the solution

where i was check the @pid is not null, that insert doesn,t work.

now it's fine

Thanks