How can I make this report query show only the most current note?
SELECT prod.COMPONENTNAME "Product",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject",ti.FIRST_NAME "Support Rep",LEFT(LTRIM(REPLACE(wo.DESCRIPTION,'\r\n',' ')),200) "Description",LEFT(LTRIM(REPLACE(nt.NOTESTEXT,'\r\n',' ')),200) 'Notes' FROM WorkOrder wo LEFT JOIN WorkOrder_Product wo_prod ON wo.WORKORDERID=wo_prod.WORKORDERID LEFT JOIN ComponentDefinition prod ON wo_prod.PRODUCT_ID=prod.COMPONENTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Account woacc ON wo.WORKORDERID=woacc.WORKORDERID LEFT JOIN Customer cust ON woacc.ACCOUNTID=cust.CUSTOMER_ID LEFT JOIN AaaOrganization org ON cust.CUSTOMER_ID=org.ORG_ID LEFT JOIN Notes nt ON wo.WORKORDERID=nt.WORKORDERID WHERE ((((org.NAME = 'ASE Group (ASE Global)') OR (org.NAME = 'ase.com (See ASE Group)')) AND (std.STATUSNAME = 'Open')) AND (wo.DEPARTMENTID = 1)) AND wo.ISPARENT=1 ORDER BY 1,2