Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Feb 26th, 2011  |  syntax: MySQL  |  size: 0.56 KB  |  views: 127  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. table one
  2.  
  3.  
  4. product         c      
  5. ==========================================
  6. sample_1        Line
  7. sample_1        LLk
  8. sample_1        LLk
  9. sample_1        LLk
  10. sample_1        LLk
  11. sample_2        LLk
  12. sample_3        LLk
  13. sample_2        LLk
  14. sample_3        LLk
  15. sample_2        Line
  16.  
  17. Plus this table two
  18.  
  19.  
  20. a               h               r      
  21. ==========================================
  22. LLk             sample_1        gw
  23. LLk             sample_2        okp
  24. LLk             sample_3        ijof
  25. Line            xe              rr3
  26. LLk             sample_4        gr2
  27. Line            xx2             o3
  28.  
  29.  
  30. Finally will be like this..
  31.  
  32. based on searching from table 2 where a=LLk
  33. product         counts
  34. ============================
  35. sample_1        4
  36. sample_2        1
  37. sample_3        2
  38. sample_4        0
clone this paste RAW Paste Data