seems simple and obvious but not when the columns have different keys, and there could be one or more keys to match upon. i would be curious to see how you can prompt that?

and you are correct, you just need to know how to prompt it correctly by going back to first principles, just like what i did.