"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 r
* 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 ca
> SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND b.name='joe' OR
> b.name='bill';
> however, this would return any companies that has ONLY one Bill or one Joe
> .. I only want companies that
> have BOTH. It also returns one row with the company per name it found, so
> you can imagin
