All pastes #182673 Raw Edit

Unnamed

public text v1 · immutable
#182673 ·published 2006-09-26 07:45 UTC
rendered paste body
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>