Negated SELECT query

------=_NextPart_000_0090_01C9A71F.64C8B630
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

3 tables are related by one-many links. 
Employees  ---<-  Assets  ---<-  Maintenance 

Employees can be assigned  =3D> 0   Assets 
Assets can have  =3D> 0  occurances of  Maintenance.  

Assets table contains  EmployeeIDs  and  MaintenanceIDs,  
but no Foreign Key contraints.  


Queries ...  
1)  which Employees do not have any  Assets =3F 
2)  which  Assets  have not had any  Maintenance =3F 
These have been written successfully with Sub-Queries,  

I would like to know how they can be done with only JOINs  =3F 
(that also means  without the EXCEPT statement) 
Is that too much of a challenge =3F      (MySQL  5.0.67)  







-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12747 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

------=_NextPart_000_0090_01C9A71F.64C8B630--