We have two tables - one is the
_click table and the other is a catalog of
ProductIDs and we'd like to find all the clicks from the previous day where the ProductID is in the
The problem is the
ProductID data is not an exact match, but is
like the value in
LinkContent and so I don't know how to add the wildcards to find the matches.
LinkContent = http://www.somedomain.com/1234?utm_campaign=...
Value in Table ProductID is 1234