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
>> 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
> 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
>
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:
>
> 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
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
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
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
> 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
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
Wednesday, July 02, 2003 10:56 AM
> To: [EMAIL PROTECTED]
> Subject: Newbie SELECT problem
>
>
> Hello everyone,
>
> I have the following select statement
>
> SELECT DISTINCT sessionID, userID, date, time
> FROM sti_tracking
> WHERE userID = 999
>
> What I
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
sessionID nor
Hi All
I am trying to compare information in 2 different tables and return
matches. The problem is that this query only returns the listings where
I want it to return a row from AutoEmail when it finds a match.
What am I doing wrong?
SELECT * FROM AutoEmail, listings WHERE ((listings.prop_styl
13 matches
Mail list logo
