title: searching multiple tables in a postgres DB with a single query?
body: <p>I'm trying to search multiple tables in a single database but I'm not having any luck.</p>
  
  <p>I have two tables, Cities and Countries and I want a single search that finds results from both/either</p>
  
  <p>Something like this -</p>
  
  <pre><code>SELECT * FROM cities &amp;&amp; countries WHERE name ='New York'
  </code></pre>
  
  <p>Any help would be awesome!</p>