RE: [mysql] duplicating lines

2007-09-14 Thread Weston, Craig (OFT)
To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: [mysql] duplicating lines Hi Craig, would you mind posting the SHOW CREATE TABLE for the tables in question? I'm having trouble determining what is the primary key for your service ticket table... Thanks, -Jay Weston, Craig (OFT

Re: [mysql] duplicating lines

2007-09-14 Thread Baron Schwartz
why this isn't working. Can anyone offer an insight? Thank you, Craig -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 1:27 PM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: [mysql] duplicating lines Hi Craig, would you

RE: [mysql] duplicating lines

2007-09-14 Thread Weston, Craig \(OFT\)
: Friday, September 14, 2007 12:28 PM To: Weston, Craig (OFT) Cc: Jay Pipes; mysql@lists.mysql.com Subject: Re: [mysql] duplicating lines I think you want to use a GROUP BY query. Try this article: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row -per-group-in-sql/ Baron Weston

[mysql] duplicating lines

2007-09-13 Thread Weston, Craig \(OFT\)
Hello again, I am having a duplication of results problem. I believe my query (below) is giving me exactly what I deserve in writing it. What it returns to me is a row for each status. What I would most want would be a single row with the oldest status - IE the status datetime

Re: [mysql] duplicating lines

2007-09-13 Thread Jay Pipes
Hi Craig, would you mind posting the SHOW CREATE TABLE for the tables in question? I'm having trouble determining what is the primary key for your service ticket table... Thanks, -Jay Weston, Craig (OFT) wrote: Hello again, I am having a duplication of results problem. I