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 =
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