79249409

Date: 2024-12-03 22:59:03
Score: 0.5
Natty:
Report link

You can use LEFT Join and a NULL condition

SELECT a.Id, a.appleId
FROM TableA a
LEFT JOIN TableB b ON a.appleId = b.bappleId
WHERE b.bappleId IS NULL;

Output

enter image description here

Reasons:
  • Whitelisted phrase (-1.5): You can use
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: samhita