MySQL: query with joining two tables

In my last project had to compare two different tables. Table ‘itemsaldo’ contained whole warehouse stock and in table ‘holdlist’ were products blocked by Quality Department.

Attention! This post has been published on my old website that has been down. I’m archiving old not verified posts for possible future use. Please be careful when using this post content.

In order to create SQL query this site helped me a lot: publicmind.in

To extract good quality materials and to show all columns form ‘itemsaldo’ table I’ve used this query:

Select * from itemsaldo left join holdlist on itemsaldo.LOCATIONINFO = holdlist.LOTWZ where holdlist.LOTWZ is NULL;

Table ‘itemsaldo’ had 105 rows originally. Result of this query were 103 rows what means 2 LOT numbers have been blocked by QA. But I had to extract only LOT numbers from ‘itemsaldo’ table. Therefor I’ve used following SQL query:

Select LOCATIONINFO from itemsaldo left join holdlist on itemsaldo.LOCATIONINFO = holdlist.LOTWZ where holdlist.LOTWZ is NULL;

But – yes, there is one more but – had to create query to shows only good quality LOTs with model’s criteria chosen by user in combobox:

Select LOCATIONINFO from itemsaldo left join holdlist on itemsaldo.LOCATIONINFO = holdlist.LOTWZ where holdlist.LOTWZ is NULL AND itemsaldo.ARTICLENO='6308L-5138A';

50 thoughts on “MySQL: query with joining two tables

  1. Pingback: Golden Eagle Tallahassee

  2. Pingback: Bitcoin Era - The Official Bitcoin Era App

  3. Pingback: bitcoin evolution reviews

  4. Pingback: see

  5. Pingback: bitcoin loophole review 2020

  6. Pingback: Immediate Edge

  7. Pingback: blazing trader

  8. Pingback: frontier airlines Phone Number

  9. Pingback: Plumber Near Me

  10. Pingback: Immediate Edge Review 2020

  11. Pingback: btc loophole qatar

  12. Pingback: Riverpoker

  13. Pingback: blazing trader review

  14. Pingback: mơ thấy con cá đánh đề con gì

  15. Pingback: Electricity Plans

  16. Pingback: mơ mình chết đánh con gì

  17. Pingback: Pinballs for Sale Online

  18. Pingback: Hand raised parrots for sale

  19. Pingback: 홀덤사이트

  20. Pingback: ป๊อกเด้งออนไลน์

  21. Pingback: 안전놀이터

  22. Pingback: nằm mơ thấy sập nhà

  23. Pingback: mơ thấy bơi trong nước

  24. Pingback: mơ thấy tàu thuyền đánh con gì

  25. Pingback: 먹튀검증

  26. Pingback: Buy male sex dolls online

  27. Pingback: VR80 12ga Shotgun

  28. Pingback: nam mo thay mau

  29. Pingback: mơ thấy con cóc

  30. Pingback: XFINITY Store by Comcast

  31. Pingback: Harold Jahn Canada

  32. Pingback: nằm mơ thấy chó đẻ

  33. Pingback: nằm mơ thấy mẹ bị bệnh

  34. Pingback: nằm mơ thấy kim cương

  35. Pingback: trò chuyện với người nổi tiếng

  36. Pingback: nằm mơ thấy nhà mới

  37. Pingback: satta king

  38. Pingback: m918kiss

  39. Pingback: mơ đánh vợ

  40. Pingback: Stiiizy starter kit

  41. Pingback: mơ thấy xương người

  42. Pingback: mơ thấy trả nợ

  43. Pingback: cung song ngư nam

  44. Pingback: quality engineering - QE

  45. Pingback: mơ thấy thầy giáo cũ

  46. Pingback: chiem bao thay di chua

  47. Pingback: cibc online banking login

  48. Pingback: game bai catte

  49. Pingback: tennis truc tuyen

Leave a Reply

Your email address will not be published. Required fields are marked *