my query is
i want to update the other table "result" from the total of ansSELECT count(*) as total_score,userdata.first_name,last_name,degree,email_address,nic,university,address,contact,company,age,gender FROM ans inner JOIN userdata on
ans.bio_id = 250 and userdata.bio_id =250
AND
ans.isCorrect = 1 UNION (UPDATE ANS WHERE bio_id=250)
what is the correct way please guide me
any help will be much appreciated