Untitled

SELECT CONCAT('Native Desktops and Laptops');
SELECT Location.Campus, NativeDesktop.Desktop, NativeLaptop.Laptop
FROM
(
SELECT q.Campus AS "Campus", count(p.AssetTag) AS "Desktop"
FROM Asset AS p, Assignment AS q
WHERE
q.EndDate = '0000-00-00'
AND p.Type = 'Desktop'
AND q.Purpose = 'Native'
AND p.Status_Current = 'In Service'
AND p.AssetTag = q.AssetTag
GROUP BY q.Campus



SELECT *
FROM `Asset`
WHERE Status_Date > '2006-01-01'
AND Status_Date < '2007-06-30'
LIMIT 0 , 30