i have 2 table :
tb_code(ident,c_code,id_glaccnt_rev,id_glaccnt_cost)
tb_gl(ident,c_glno)

id_glaccnt_rev have a relation with the ident of tb_gl
id_glaccnt_cost have a relation with the ident of tb_gl

so i want to make a select of all code in tb_code with c_glno of id_glaccnt_rev and the c_glno of id_glaccnt_cost

How can i do this ????