RE: I can't figure out what I thought would be a simple query..

2003-10-28 Thread Mike Knox
e- From: Larry Brown [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 22:30 To: Jim Matzdorff; MySQL List Subject: RE: I can't figure out what I thought would be a simple query.. I'm interested to see what kind of solution is offered for this as I could use it myself. I'm having to

Re: I can't figure out what I thought would be a simple query..

2003-10-27 Thread Matt W
ike the subselect method would have this problem also. Can someone tell me if this is true or am I thinking wrong? Hmm. Hope that helps. Matt - Original Message - From: "Larry Brown" Sent: Monday, October 27, 2003 4:29 PM Subject: RE: I can't figure out what I thought w

RE: I can't figure out what I thought would be a simple query..

2003-10-27 Thread Larry Brown
I'm interested to see what kind of solution is offered for this as I could use it myself. I'm having to do this programatically on an expternal script that selects distinct non_unique_id and the takes the result and loops through each one with sort by endtime desc limit 1 and then either do someth