Multiple update query into single query

sksoni75 · #1 (**permalink**) 01-15-09, 04:28

hi

I have used two update query. i want to change this query into one so that i can update the table in single query run.

1. UPDATE RawExtract INNER JOIN PDB ON RawExtract.[buyer-Location_id]=PDB.Partner_Id SET RawExtract.Membership = PDB!DB_Membership;

2. UPDATE RawExtract INNER JOIN PDB ON RawExtract.[buyer-Location_id]=PDB.Partner_Id SET RawExtract.Partner_Clubbed_ID = PDB!Partner_Clubbed_ID;

Regards
Santosh

r937 · #2 (**permalink**) 01-15-09, 07:10

Code:

UPDATE RawExtract 
INNER 
  JOIN PDB 
    ON PDB.Partner_Id = RawExtract.[buyer-Location_id]
   SET RawExtract.Membership = PDB!DB_Membership
     , RawExtract.Partner_Clubbed_ID = PDB!Partner_Clubbed_ID

sksoni75 · #3 (**permalink**) 01-15-09, 23:10

Hi Friend r937,

Its worked, thanks a ton.

Internet Services

Web Development

Digital Marketing

Consumer Tech