[thelist] SQL selecting distinct from multiple index tables
David Siedband
david at calteg.org
Fri Jan 30 23:24:08 CST 2004
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 unique organizations 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
More information about the thelist
mailing list