All The Ids In Temp2 Should Have Same Client And Drug (was Need Sql Help - Urgent)

I have following tables

Temp1

ID Client Drug
3889aa A
4998cc A
4998dd B
8011ff C
8011gg A

and Temp2

ID Client Drug
8011ff C
8011gg A



I have a conditional loop which changes the values of these 2 tables. I populate temp2 by getting all the similar ids from temp1. e.g: first time 3889 then 4998 then 8011.

my task is, all the ids in temp2 where temp2.id<>temp1.id should have same client and drug. if 8011 has client bb and drug B then 4998,3889 should also have client bb and drug B in them.

if 4998 has client dd and drug B then 8011, 3889 should also have client dd and drug B and so on. means all the records in temp1 should contain similar clients and drugs in them in actual table. I'll need to add the missing client and drug for the ID where its misiing in actual table.

After this process my actual drug table will look like:


ID Client Drug

3889 dd B
3889 cc A
3889 aa A
3889ff C
3889gg A
4998 dd B
4998 cc A
4998 aa A
4998ff C
4998gg A
8011 dd B
8011 cc A
8011 aa A
8011ff C
8011gg A


How can I achive this goal. Please help...