Hi all - I've got a database along the lines of the following
---------------- -------------- ---------------- | Transactions | | Products | | TransDetails | ---------------- -------------- ---------------- | TransID | | ProdID | | TransID | | TransDate | | ProdName | | ProdID | | ..... | | .... | | ..... | ---------------- -------------- ---------------- (I have replaced a bunch of other fields with .... for briefity) What I need to be able to do is get a list of all products not having a transaction since a certain date, but am not having much luck. Anyone out there willing to offer save my day? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]