匹配不匹配的字段?

I've been trying to set up simple queries for a customer to match their product sheet with the wholesaler's price catalog. The only issue that I've run into is the company formatted their items using only the SKU of the product, whereas the pricer has them listed as MFC-SKU. I've come up with a couple ways to work around this, but I'm having a hard time overall as I'm new to Access.I've been trying to set up simple queries for a