title: how to gat data form table1 which does't contains that id and user name in table2
body: <p>I have a tables like Table 1 and Table2</p>
  
  <p>Table1 contains</p>
  
  <pre><code>id  |  area  | Merchant
  -----------------------------
  1   | Area1  | Merchant1
  -----------------------------
  2   | Area1  | Merchant2
  -----------------------------
  3   | Area2  | Merchant3
  -----------------------------
  4   | Area3  | Merchant4
  -----------------------------
  </code></pre>
  
  <p>Table2 contains</p>
  
  <pre><code>id  |merchant_id| user_id
  -----------------------------
  1   | 1         | user1
  -----------------------------
  2   | 2         | user2
  -----------------------------
  3   | 1         | user2
  -----------------------------
  4   | 1         | user3
  -----------------------------
  </code></pre>
  
  <p>My question was, I want to show the merchant names from the Table1 but it should not contains in Table2 for the users when they longed in.</p>
  
  <p>This Query not working please help me</p>
  
  <pre><code>SELECT t1.id,t1.merchant
  FROM table1 AS t1 ,table2 AS t2
  WHERE (t1.id NOT LIKE t2.merchant_id AND t2.user_id NOT LIKE 'user1') AND
        t1.area like 'area1' 
  </code></pre>