categories c ON a.assetcategoryID = c.assetcategoryID
WHERE m.assetID IS NULL
ORDER BY a.assetID
Cheers
- Original Message -
From: "Bonnett, John"
To: ;
Cc: ;
Sent: Tuesday, March 17, 2009 10:59 PM
Subject: RE: Negated SELECT query
SELECT Employees.*
FROM Employees
@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: Negated SELECT query
3 tables are related by one-many links.
Employees ---<- Assets ---<- Maintenance
Employees can be assigned => 0 Assets
Assets can have => 0 occurances of Maintenance.
Assets ta
On Tue, Mar 17, 2009 at 12:42 PM, BobSharp wrote:
> These have been written successfully with Sub-Queries,
> I would like to know how they can be done with only JOINs ?
http://dev.mysql.com/doc/refman/5.0/en/rewriting-subqueries.html
- Perrin
--
MySQL General Mailing List
For list archives: ht
3 tables are related by one-many links.
Employees ---<- Assets ---<- Maintenance
Employees can be assigned => 0 Assets
Assets can have => 0 occurances of Maintenance.
Assets table contains EmployeeIDs and MaintenanceIDs,
but no Foreign Key contraints.
Queries ...
1) which Employee
