by: [EMAIL PROTECTED]
06/24/2003 09:00 AM
Please respond to CF-List
To: [EMAIL PROTECTED]
cc:
Subject: RE: [KCFusion] an easy one
Adaryl,
Mark has given you pretty good clarification (although DISTINCT in conjunction with GROUP BY can be
helps,
Girish
"Boles, Mark E" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/24/2003 12:17 AM
Please respond to CF-List
To: <[EMAIL PROTECTED]>
cc:
Subject: RE: [KCFusion] an easy one
also...
> SELECT
TECTED]Sent: Tuesday, June 24, 2003
12:18 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion]
an easy one
also...
> SELECT DISTINCT
table1.studentID, table2.goalID
> FROM table1,
table2
> WHERE table1.studentID =
table2.studentID
the
distinct behavior...
I be
[KCFusion] an easy
one
Girish do you have a real world example of the
proper usage of the group by clause? My book is real weak on this
subject.
A.
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 23, 2003 5:00 PM
Subject: RE: [KCF
ubject: Re: [KCFusion] an easy
one
Girish do you have a real world example of the
proper usage of the group by clause? My book is real weak on this
subject.
A.
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 23, 2003 5:00 PM
Subje
Girish do you have a real world example of the
proper usage of the group by clause? My book is real weak on this
subject.
A.
- Original Message -
From:
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 23, 2003 5:00 PM
Subject: RE: [KCFusion] an easy one
FROM table1
Keep in mind that I'm no SQL guru...
Tyson
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] an easy one
Yes
- Original Message -
From: &l
guru...
Tyson
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] an easy one
Yes
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, J
Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] an easy one
Yes
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 3:56 PM
Subject: R
Yes
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 3:56 PM
Subject: RE: [KCFusion] an easy one
> Are the studentID and goalID unique when combined?
>
> -Original Message-
> From: Adaryl Wakefield [mailto:
-4273 Office
913-568-7961 Mobile
~~
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 3:55 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] an easy one
Tried that still got a funny record set. Here is a simplifaction of
Are the studentID and goalID unique when combined?
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 3:55 PM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] an easy one
Tried that still got a funny record set. Here is a simplifaction of the
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 3:31 PM
Subject: RE: [KCFusion] an easy one
> SELECT DISTINCT id
>
> -Original Message-
> From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 3:33 PM
> To: [EMAIL PROTE
Try DISTINCT instead of Unique
Frederick Hale
R.O.A.M. Support
*Phone: 816-391-7745
* Fax: 816-391-5027
*E-Mail: [EMAIL PROTECTED]
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 3:33 PM
To: [
SELECT DISTINCT id
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 3:33 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] an easy one
Its been so long since ive done this i forgot how. In an sql statement i
want only unique values of a field. I
15 matches
Mail list logo