I need to find the best way to join another table using a like in the join.
What I have is a query that has a inner join, and left outer join and it is working.
The first part of the query (with the inner join) joins 2 tables together to look for and calculate device events and their duration. The outer join pulls in any event messages if any.
Now what I need to do is join yet another table if the device name appears in one of two fields in another table. So if the device name from the first query appears somewhere in the summary or description fields in the last joined table I need to pull in additional information.
So what I am looking for a way to do this is like
outer left join HelpDesk HPD
.. if QueryA.DeviceName appears somewhere in the HPD Sumamry or Description fields