Hey all I am in need of some help with my query. I am testing this out with 2 users. However, it only seems to show the first user and never the other one. Here is my query string.
SELECT productr.id, staybridgedb.productr.itemPrice, productr.itemName,
SUM(productr.itemsSold) AS ITEMSSOLD,
SUM(productr.itemPriceTotal) AS PRICETOTAL,
SUM(productr.transactTotal) AS TRANSTOTAL,
SUM(productr.itemTax) AS TAX,
SUM(productr.transactTotalTax) AS TOTALWITHTAX,
FROM productr, empid
WHERE productr.empid = empid.UniqueID
AND itemRUDate >= '2009/09/03'
GROUP BY itemName DESC
It displays fine for the first user but never shows anything for the second user. And i've also checked to make sure the "UniqueID" is different for both of them and that it has the same dates "2009/09/03" when looking through the receipts.