title: Select column from table1 which is not in table2
body: <p>I have two table</p>
  
  <pre><code>table1
  =======================================
  tid    subcategory     category
  ---------------------------------------
  1      SUBCATEGORY1    CATEGORY1
  2      SUBCATEGORY1    CATEGORY2
  3      SUBCATEGORY2    CATEGORY1
  4      SUBCATEGORY3    CATEGORY1
  5      SUBCATEGORY4    CATEGORY1
  6      SUBCATEGORY5    CATEGORY1
  7      SUBCATEGORY6    CATEGORY1
  8      SUBCATEGORY7    CATEGORY1
  9      SUBCATEGORY8    CATEGORY1
  10     SUBCATEGORY9    CATEGORY1
  
  
  table2
  =======================================
  t2id   subcategory     category  pid
  ---------------------------------------
  1      SUBCATEGORY1    CATEGORY1  1
  2      SUBCATEGORY1    CATEGORY2  1
  3      SUBCATEGORY2    CATEGORY1  1
  </code></pre>
  
  <p>I try to show all rows of table1 which is not in table2, the result should be like this...</p>
  
  <pre><code>=======================================
  tid    subcategory     category
  ---------------------------------------
  4      SUBCATEGORY3    CATEGORY1
  5      SUBCATEGORY4    CATEGORY1
  6      SUBCATEGORY5    CATEGORY1
  7      SUBCATEGORY6    CATEGORY1
  8      SUBCATEGORY7    CATEGORY1
  9      SUBCATEGORY8    CATEGORY1
  10     SUBCATEGORY9    CATEGORY1
  </code></pre>
  
  <p>I am using this query...</p>
  
  <pre><code>select tl.* from table1 tl where subcategory and category not in(SELECT tl.subcategory, tl.category  FROM table1 as tl join table2 as bm where bm.pid='1' and tl.subcategory=bm.subcategory and tl.category=bm.category);
  </code></pre>
  
  <p>but it not working help please...</p>