Re: [vox-tech] SQL selecting distinct from multiple index tables (solution)

2004-01-31 Thread Ted Deppner
On Fri, Jan 30, 2004 at 10:04:35PM -0800, David Siedband wrote: ahh, I just got this to work. Here's the query I used (MySQL 3.x) select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , OrgProjects , Organizations where (OrgDocs.OrgID =

Re: [vox-tech] SQL selecting distinct from multiple index tables (solution)

2004-01-30 Thread David Siedband
ahh, I just got this to work. Here's the query I used (MySQL 3.x) select distinct Organizations.OID , Organizations.Name , Organizations.Acronym from OrgDocs , OrgProjects , Organizations where (OrgDocs.OrgID = Organizations.OID) or (OrgProjects.OrgID = Organizations.OID) still interested in