title: Selecting max from join of 2 tables in sqlite
body: <p>I need a small help with selecting a max value of a column of two tables. When I run the sql statement below, I get maximum from both tables, ie 2 rows. How can I get the maximum of both of them (SQLITE 3)?</p>
  
  <blockquote>
    <p>Select max(transid) from tbltrans union select max(transid) from
    tbltrans2</p>
  </blockquote>
  
  <p>Thanks anyway.</p>