title: Trying to do a LEFT JOIN, but ending up getting empty result
body: <p>I tried doing a LEFT JOIN (the one on the image second of the left). So basically I want all records from table A without the records from table B, so I want to take only the information from table B that crosses with table A. There is more info like book details in table B that I want to be able to extract, but I don't need of the rows from table B, just the extra info. I figure the best way to do this is with LEFT JOIN and this is the code I tried, but it result in a empty string/result:</p>
  
  <p><code>SELECT WF.*, W.* FROM WalletFrom AS WF LEFT JOIN Wallet AS W ON W.BookID = WF.BookID WHERE WF.BookID = 1360 AND W.BookID IS NULL</code></p>
  
  <p>What I am doing wrong?</p>
  
  <p>Columns from Wallet:
   WalletID
  UserID
  BookID
  OrderID
  WalletStatusID
  Win
  WalletProductID</p>
  
  <p>Columns from WalletFrom:
  OrderID
  BookID
  Count
  Win
  WinTotal
  Tax
  WinEnd
  DateTime
  WalletProductID
  <a href="https://i.stack.imgur.com/DOxik.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DOxik.png" alt="enter image description here"></a></p>