Hi, You could also use the request ID as it will be sequenced, there are existing joins available for Incident / Work Info that can be utilised.
_____ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 07 January 2015 21:38 To: arslist@ARSLIST.ORG Subject: Re: Determining first workinfo entry ** do a MIN on the create_date for the work log entry...this'll ensure you only get the first entry. On Wed, Jan 7, 2015 at 2:33 PM, Scott Hallenger <vadr...@yahoo.com> wrote: Hi I am creating a report via sql, that would show several incident fields and 2 fields fromn the HPD:Worklog forms. Naturally this would be a join, but I am trying to figure out which is the best way to single out the first/earliest workin info entry and exclude the rest. As you know the worklog can have more than one entry related to the single incident. Any Ideas would be helpful. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
