i have 2 tables. first table named std_table :
| ID_std | std_1 | std_2 | std_3 | std_4 | std_5 | | 115 | A | B | A | C | D |
then i gave another table named cpr_table :
| ID_cpr | ID_std | cpr_1 | cpr_2 | cpr_3 | cpr_4 | cpr_5 | | 123 | 115 | A | C | A | D | D |
i need a query to compare those two tables to have some result like this :
| ID_cpr | ID_std | cpr_1 | cpr_2 | cpr_3 | cpr_4 | cpr_5 | VALUE | | 123 | 115 | A | C | A | D | D | 7,5 |
Value gets 7,5 because std_1 = cpr_1 ( i give 2,5 points ), std_2 != cpr_2 (i give 0 points), std_3 = cpr_3 ( i give 2,5 points ), std_4 != cpr_4 ( i give 0 points ) and std_5 = cpr_5 ( i give 2,5 points ).
what would it be for the expression? i use case expression but it didn't work.
i hope i could explain better. any sugestion for my problem?