title: How to join two tables if there is no relation between id and idfk
body: <p>I've two tables <code>table1</code> and <code>table2</code>. Those tables do not have any relationship between them. I mean there is no <code>t1.id = t2.idfk</code>. I need to take one column from <code>table2</code> and put it into select where are many rows from <code>table1</code>. There is a column <code>idfk</code> which is an <code>idfk</code> in <code>table1</code> and <code>table2</code>. Is it okay to use the following SQL query?</p>
  
  <pre><code>select t1.id, t2.name
  from table1 t1, table2 t2
  where t1.addressidfk = t2.addressidfk
  and t1.addressidfk = 3003`
  </code></pre>