I want to show same field form database each with different conditions in datagrid.I use oracle as back-end.For that,I use 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:
System.Data.OracleClient.OracleException: ORA-00936: missing expression

Aneri:
Try placing a semi-colon ";" at the end of the SQL statement before the last double quotes (i.e. as is = "'", to be = "';")

Hope this helps.