title: Search SQL query from multiple tables MySQL
body: <p>I am trying to perform search on multiple tables. </p>
  
  <p>I will simplify problem and say that I have 2 tables <code>Worker</code> and <code>Customer</code> both have <code>Id, Name, Surname</code> and <code>Worker</code> has additional <code>Position</code>, all fields are <code>varchar</code> except <code>Id</code> which is <code>Int</code>.</p>
  
  <p>How to make a query that will return rows of either <code>Customer</code> or <code>Worker</code>, where one of theirs fields contains entered search string.</p>
  
  <p>I have tried with joins but I got returned joined row also.</p>