Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    4

    Question Unanswered: Filtering Record Output

    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.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    ahh, it is right behind door #1


    You might want to provide a table structure and take a first stab at it.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •