select fieldname based on query result
i have three table
2)grpmgt_sub (this is subtable of lgn_grpmgt)
"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