title: Finding max value of a field available in all tables
body: <p>Example scenario:
  5 tables are there and one common field among them is com_field (DATE data type). Now, I need to find the maximum of com_field in each of the five tables. Can someone give the logic?</p>
  
  <p>I know UNION could be used but I need the flexibility not to miss any new table added to the OWNER.</p>
  
  <p>The result I am expecting is like the below.</p>
  
  <pre><code>Table Max(com_field)
  Tbl1  10/21/2019
  Tbl2  10/18/2019
  Tbl3  10/28/2019
  Tbl4  09/30/2019
  Tbl5  09/09/2019
  </code></pre>