Hi
i have table with 4 coloum
first 3 contain input and last one contain output
my query.
in the table if all 3 input Coloum have any value it give output in 4 coloum 150
in the table if all 2 input Coloum have any value and one is blank, it give output in 4 coloum 100
in the table if all 1 input Coloum have any value and 2 are blank, it give output in 4 coloum 50
in the table if all 3 input Coloum are blank, it give output in 4 coloum 0
Coloum 1 coloum 2 coloum 3 output
10 20 30 150
10 20 100
10 50
0
Bookmarks