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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
