Query two lookup tables

    Date: 03/20/06 (MySQL Communtiy)    Keywords: software

    Two tables exist:

    knowledgebase main knowledge base table, primary key is knowledgeid
    knowledgebase_softwareversion lookup table containing knowledgeid and verid
    knowledgebase_operatingsystem lookup table containing knowledgeid and osid

    Is it possible to create a single query that will show all Knowledge Base entries that match osid=1, osid=2, osid=6, and verid=3, verid=9, verid=44, verid=13?

    Thanks!

    Source: http://community.livejournal.com/mysql/90045.html

« Query Question || SELECT DISTINCT and WHERE... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home