i've created a table with the following columns : a,b,c the values in "a" are 1,2,3,4,5 (for example) the values in "b" are 6,7,8,9,10 (for example) the values in "c" are 11,12,13,14,15 (for example,again) the table looks that way a b c ______ 1 6 11 2 7 12 3 8 13 4 9 14 5 10 15 let's look on the second line, and imagine that the user selected "2" i need a code that gets only "7" when "2" exists (which means that 12 is meanless in that case) thanks in advance
a more precise query would be select b from tablename where a = value .If u want the value to be chosen on run time use this one .
try using split, am not able to place much logic on this at this moment, but I have done this months back in a project