I'm a hack at best with SQL. I want to only display a record if a string from a field in query 2 is found in a particular field in query 1.

query 1 output looks like this:

Microsoft .NET Framework 1.1 Security Update (KB953297)
Security Update for Microsoft Office Access 2007 (KB979440)
Security Update for Microsoft Office Outlook 2007 (KB972363)
Security Update for Microsoft Office Word 2007 (KB2251419)
Windows Installer 3.1 (KB893803)
Security Update for Microsoft .NET Framework 2.0 (KB917283)
Security Update for Windows XP (KB890046)

query 2 output looks like this:

981716
979440
2229593
2286198
980436

So I only want to display a record from query 1 if it contains one of the values found in the list of values in query 2.

Thanks.

ahh, it is right behind door #1


You might want to provide a table structure and take a first stab at it.