Forum Discussion
pattern matching in ms access query
i have table T1 with query, name T2 table pattern , category Query can be anything t2 table pattern2 category connection*failure* connectivity power*failure* ...
In MS Access, you can’t use LIKE in the join.
Do this instead:
SELECT t1.query, t2.pattern2, t2.category
FROM t1, t2
WHERE t1.query LIKE "*" & t2.pattern2 & "*";
👉 Put LIKE in the WHERE clause, not the join.