Re: companies that are located in San francisco & Chicago

On Mon, Aug 09, 1999 at 03:46:40PM +0100, Obnoxio The Clown wrote: > From: msnlb <msnlb@hotmail.com> > > > >I am trying to find how to locate companies that have > >offices in San Francisco & in Chicago. Does anyone know how > >to do this? I have been working on it for 2 weeks. Any > >suggestions would be greatly appreciated. > > Have you thought about a phone book? Anyway, what the hell has this got to > do with Informix anyway? SELECT UNIQUE a.company_name FROM companies a, company_offices b, company_offices c WHERE a.company_id = b.company_id AND b.city = "San Francisco" AND a.company_id = c.company_id AND c.city = "Chicago" This should get the result :-) -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com