Example equijoins. : Non equality table join « Table Joins « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table Joins
3. Non equality table join

SQL>
SQL> SELECT a.table_name,b.column_name
  2      FROM dba_tables a, dba_tab_columns b
  3      WHERE a.table_name = b.table_name
  4      and  rownum < 50
  5      AND a.tablespace_name = 'GRAPHICS_DATA';

no rows selected

SQL>