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
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
: 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
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
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