title: Create Query to join 2 tables 1 on 1 with nothing in common
body: <p>I have a table TAB_1 which has 230 rows.</p>
  
  <pre><code>CREATE TABLE TAB_1 (audit_id bigint NOT NULL PRIMARY KEY)
  </code></pre>
  
  <p>I have another table TAB_2 which also has 230 rows. </p>
  
  <pre><code>CREATE TABLE TAB_2 (employee_id bigint NOT NULL PRIMARY KEY, first_name varchar(50) NOT NULL, last_name varchar(50) NOT NULL)
  </code></pre>
  
  <p>Both these tables have nothing in common. </p>
  
  <p>I want to write a query which will give me all the columns in these 2 tables 1 on 1 (i.e. 1st row of TAB_1 with 1st row of TAB_2, 2nd row of TAB_1 with 2nd row of TAB_2 and so on). That query will also have 230 rows. </p>
  
  <p>How can I do that? </p>
  
  <p>I tried these queries but they are given result as every row in TAB_1 times every row in TAB_2:</p>
  
  <pre><code>select a.audit_id, b.employee_id, b.first_name, b.last_name
  from TAB_1 a inner join TAB_2 b on 1 = 1
  
  select a.audit_id, b.employee_id, b.first_name, b.last_name
  from TAB_1 a cross join TAB_2 b 
  </code></pre>