select fieldname based on query result

[kasimacsys]

Hi,

i have three table
1)lgn_grpmgt
2)grpmgt_sub (this is subtable of lgn_grpmgt)
3)lgn_menumgt

"lgn_grpmgt" having the field like 'grpid','grpname'
"grpmgt_sub" having the field like 'grpid','menuid'
"lgn_menumgt' having the field like 'menuid','menuname'

i want to get the column 'menuid' from "grpmgt_sub" and 'menuname' for the corresponding 'menuid' from "lgn_menumgt" where grpid='grp id i pass'

pls send me the query for this, it ll be very helpful for me

thanks

[gandolf989]

Take a look at the case command. You can use to to choose which column to output.