I currently have the following SQL:
SELECT ASSETTABLE.ASSETID, ASSETTABLE.NAME, ASSETTRANS.TRANSTYPE, ASSETTRANS.TRANSDATE FROM ASSETTABLE INNER JOIN
ASSETTRANS ON ASSETTABLE.ASSETID = ASSETTRANS.ASSETID AND ASSETTABLE.DATAAREAID = ASSETTRANS.DATAAREAID
Assettable is a list of all assets. Assettrans is a list of all asset transactions for items from Assettable.
What I want to do is to exclude all items from the dataset which have a record in AssetTrans where Transtype=10 and transdate<01/11/2010. How do I write this please?
Thanks for all help
View Complete Post