SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND (b.name='joe' OR b.name='bill');
_____________________ Marcos Henke _____________________ ----- Original Message ----- From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Blaster" <[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 7:51 AM Subject: Re: A little problem with SELECT > * Blaster > [...] > > "main" company table > > id (int) | company name (varchar) | phone (varchar) | .. more fields that > > doesn't really matter > > > > "employee" table (company.id = employee.cid) > > id (int) | cid (int) | name (varchar) | age (int) | email (varchar) > > > > Now, I want to make a search which can search for 2 names and show me if > > there are any company that > > has these names? I tried > > > > SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND > > b.name='joe' OR > > b.name='bill'; > > Because you want to check two different names, you must join the employee > table twice: > > SELECT a.* > FROM company a, employee b1, employee b2 > WHERE > a.id=b1.cid AND > a.id=b2.cid AND > b1.name='joe' AND > b2.name='bill'; > > -- > Roger > sql > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php