title: SQL Query to Check presence of a Column of one table and a Column of another table as pair on a third table?
body: <p><a href="https://i.stack.imgur.com/Suac4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Suac4.png" alt="Table structure" /></a></p>
  <ol>
  <li>Table1.col1 contains some Names and Table2.col2 is a datetime field.</li>
  <li>Table 3 has both the two columns.</li>
  <li>I'm using Oracle database.</li>
  <li>Table3 is the master table which has more than a billion records.</li>
  <li>Table1 and Table2 has no relation/link.</li>
  </ol>
  <p>Expected output from above image:</p>
  <p><strong>I need a query to fetch all those pairs of table1.column1 and table.column2 which are not present in Table3 against the respective columns Col1 and Col2. Any Logic or an approach will be helpful.</strong></p>
  <p>Edit - The question is complete in itself because it's only looking for a logic or a pseudocode from the provided data.</p>