I am stuck on this mysql query issue involving trimming, concatenation, and field comparison.
I have 2 tables.
- In the 1st table, I have a field that needs to be trimmed based on the character '-'
- In the 2nd table, I have 3 fields that need to be concatenated.
- Finally, I need to *match* LIKE fields from both tables together.
Example data below