Re: companies that are located in San francisco & Chicago

>>>> Octav Chiriac <com@netinfo-moldova.com> 08/09/99 04:01PM >>> >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 :-) This can be simplified to SELECT what_i_want FROM where_it_is WHERE filter = "As required" Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678729 www.wfsoftware.com # If you broke it, hide the evidence ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************