[vox-tech] SQL selecting distinct from multiple index tables

David Siedband vox-tech@lists.lugod.org
Fri, 30 Jan 2004 21:24:17 -0800


I have two index tables the associate Organizations with documents and 
projects.  I'm trying to write a query that returns all the 
organizations that are associated with either a project or document.

To select distinct organization that are either associated with a 
Document or a Project, I'm using SQL that looks like this.

select distinct Organizations.OID , Organizations.Name , 
Organizations.Acronym
from OrgDocs , Organizations
where OrgDocs.OrgID = Organizations.OID

select distinct Organizations.OID , Organizations.Name , 
Organizations.Acronym
from OrgProjects , Organizations
where OrgProjects.OrgID = Organizations.OID

Any suggestions on how to combine this into a single query?

thx,

--
David