Ray, Instead of doing a join on the work log, make the column for the work log entry a separate query in the select portion, and to a select 'top 1' on the sub-query, with the proper order statements. This will give you a single work order entry in your column list, null if there aren't any at all.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ray Palla Sent: Thursday, August 09, 2012 8:32 AM To: [email protected] Subject: ITSM 7.6.04 Join form Query ** Listers Brain Test; We have an outer join form.... Primary = HPD:Help Desk and Secondary = HPD:WorkLog. It works fine and produces a list of open tickets with each Work Log entry for that ticket. The customer only wants to see the most recent Work Log entry and not any older ones. I have the join form sorted to put the most recent at the top, but haven't found a query that eliminates the other records... It may not be possible? Does anyone know a way to get just the first entry? R Ray Palla Sr. IT/Remedy Consultant <http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg> Mobile: 512-917-1739 Time Zone: Central Email: [email protected] <http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif> Professional Profile <http://www.linkedin.com/pub/1/544/598> INSONA Corporation <http://www.insona.com/> 1201 Berry Lane <http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX+77074%2CUSA&hl=en> Georgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
