<div>
gpizzuto, Thanks for the idea. I had to also include my date ranges as it was trying to look at all records in the other joined table. Now that I did that the query works!<br />
<br />
Thank you.
</div>


gpizzuto, Thanks for the idea. I had to also include my date ranges as it was trying to look at all records in the other joined table. Now that I did that the query works!

Thank you.

<div>
<div class="content wysiwyg-content">
I need to find the best way to join another table using a like in the join.<br />
<br />
What I have is a query that has a inner join, and left outer join and it is working.<br />
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.<br />
<br />
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.<br />
<br />
So what I am looking for a way to do this is like<br />
<br />
...<br />
outer left join HelpDesk HPD<br />
.. if QueryA.DeviceName appears somewhere in the HPD Sumamry or Description fields<br />
<br />
<br />
Possible?
</div>
</div>


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


Possible?

Join using a 'like'

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.