SQL> select * from id1;

       ID1	  ID2
---------- ----------
	 1
	 2

SQL> select * from id2;

       ID1	  ID2
---------- ----------
	 3
	 4

SQL> select * from id1 join id2 on id1.id2=id2.id2;

no rows selected

SQL>