RE: Newbie SELECT problem

2003-07-02 Thread Creative Solutions New Media
L PROTECTED] W: 902 450 5500 C: 902 430 8498 -Original Message- From: Peter K Aganyo [mailto:[EMAIL PROTECTED] Sent: July 2, 2003 8:00 PM To: [EMAIL PROTECTED] Subject: Re: Newbie SELECT problem Tim: Assuming that in your ealier posting the 99 was supposed to be 999, then the solution given b

Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
>> Tim: >> >> Assuming that in your ealier posting the 99 was supposed to be 999, >> then >> the solution given by Mike Hillyer is excellent and should work. >> However, when I read your new posting, I seem to get confused. The >> scenario sounds totally different - excuse me - from the earlier on

Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
> Tim: > > Assuming that in your ealier posting the 99 was supposed to be 999, then > the solution given by Mike Hillyer is excellent and should work. > However, when I read your new posting, I seem to get confused. The > scenario sounds totally different - excuse me - from the earlier one and >

Re: Newbie SELECT problem

2003-07-02 Thread Peter K Aganyo
Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: July 2, 2003 2:13 PM To: [EMAIL PROTECTED] Subject:

RE: Newbie SELECT problem

2003-07-02 Thread harsh
> > Table name "sti_tracking" > > hitID (primary key) (autonumber) > userID > sessionID > date > time > pageName this might work select userID,sessionID from sti_tracking where userID=999 group by sessionID; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Re: Newbie SELECT problem

2003-07-02 Thread harsh
select sessionID,userID,date,time from sti_tracking where userID=99 group by sessionID; hope that works ,though i didn't clearly got your question,may be some expert suggest better regards harsh On Wed, 2 Jul 2003, Tim Winters wrote: > Hello everyone, > > I have the following select stateme

Re: Newbie SELECT problem

2003-07-02 Thread Bruce Feist
Tim Winters wrote: So what I want to be able to do is single out a user (999) and retrieve all the sessions he was involved in. But I don't want duplicate session numbers (one is enough). Make any more sense? Yes. The solution I posted earlier should work. Bruce Feist -- MySQL General Maili

RE: Newbie SELECT problem

2003-07-02 Thread Tim Winters
2 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: July 2, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: Re: Newbie SELECT pr

Re: Newbie SELECT problem

2003-07-02 Thread William R. Mussatto
> Hello everyone, > > I have the following select statement > > SELECT DISTINCT sessionID, userID, date, time > FROM sti_tracking > WHERE userID = 999 > > What I want is to have only records with the userID of 99 and where the > sessionID is distinct (meaning only on of each session id). Neither

Re: Newbie SELECT problem

2003-07-02 Thread Bruce Feist
Tim Winters wrote: Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neithe

RE: Newbie SELECT problem

2003-07-02 Thread Mike Hillyer
Well, it is important to remember that SELECT DISTINCT simply restricts that the WHOLE ROW is distinct, therefore it takes into account all columns, not just the sessionID column, when deciding if a row is distinct. One way to do this would be to do SELECT sessionID, userID, date, time FROM sti_