Puzzle 55 Error in the final Select

[2b4fITin]

Seems in the WHERE clause for Matches in both table A and table B we need to add and QuantityA = QuantityB?

[smpetersgithub]

Thank you!! I will check on this. Btw, I still haven't checked the other puzzle you possibly found an error with. I will check them shortly. Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: 2b4fITin ***@***.***> Sent: Sunday, June 9, 2024 9:46:46 AM To: smpetersgithub/AdvancedSQLPuzzles ***@***.***> Cc: Subscribed ***@***.***> Subject: [smpetersgithub/AdvancedSQLPuzzles] Puzzle 55 Error in the final Select (Discussion #40) Seems in the 'WHERE' clause we need to add and QuantityA = QuantityB — Reply to this email directly, view it on GitHub<#40>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ANP5G73RUPLXBHGHR4AH2C3ZGRTFNAVCNFSM6AAAAABJA6JUCKVHI2DSMVQWIX3LMV43ERDJONRXK43TNFXW4OZWG44TQNBQGM>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[2b4fITin]

It's ok. Take your time. Thanks a lot!

[smpetersgithub]

Thank you again! I also added ProductNameA = ProductNameB for the criteria Quantities in table A and table B do not match

I need to add more records to the test data in the puzzle to create multiple instances where the product name matches, but the quantities differ.

Please let me know if you find any more errors.