self join error

I want to show a same field from database twice each with different conditions . I used self join as below:

sql2 = "select m1.int_no(select int_no from exg_main_master where o_r_tag = 'O'),m2.int_no(select int_no from exg_main_master where o_r_tag = 'R') from exg_main_master m1,exg_main_master m2 where m1.emp_no_dept_code = '" & txteno.Text & "' and m2.emp_no_dept_code = '" & txteno.Text & "'"

But I am getting error:

ORA-00936: missing expression