Hi,

my problem is resolved.

yes I have joined the tables. I could solve that by using case in the select statement.

Thanks,

Hema

Thanks a lot!

It worked. However I didn't understand the logic with insert. Why did you use left outer join and why did u compare with is null?

Once again thank...

i get an error at from with the update statment.

can't we do this with a single query? stored procedure?