scoring with IF statement

[jordan11]

Hi,
I have 4 tables

A
Oid
CSchools
CArt
CCommunity

B
Oid
CLocationState
Status


C
Pid
State
LicenseStates

D
Pid
Schools
community
Region
StateBirth
PreferredState


I need to be put on the right track. I would like to give points based on a match with another field in a different table. E.g If table B ClocationState is matchs table C LicenseStates or State or table D StateBirth or PreferredState they should get 10 points for each match and at the end I need a total of all the points. Do I just have IF statements for each one, and how do I add the points for each one if there is a match.

Thanks in advance

 

[DotNetGnat]

not clear with the question...do you want a sql query for this??

what actually are you trying to do?

-DNG

 

[jordan11]

I am in the wrong forum
Yes I will like an sql query,

Basically I have questions that have been answered by a customer and a client and I need to match the answers by the customer to the client answers and give them points for a match. There are difernt catogries of answers so at the end i want to get a total of the the catergories and then update the database.

Thanks