Perhaps create a (normalized) view that eliminates the wildcards and explicitly names every combo in the "Condition table" -> then join to the view. It sounds like the wildcards are there to make data entry easier, but they're making the table difficult to use.