maybe try.........
SELECT StudentID FROM Students
WHERE StudentID IN (
SELECT StudentID FROM Class
)
To find all the Students currently enrolled in Classes
Justin Hansen
~~~~~~~~~~~~~~~~~~~~~~
Uhlig Communications
Systems Engineer
~~~~~~~~~~~~~~~~~~~~~~
[EMAIL PROTECTED]
913-754-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 the
statement
SELECT DISTINCT table1.studentID, table2.goalID
FROM table1, table2
WHERE table1.studentID = table2.studentID
I still keep getting multiple tuples for one studentID
A.
----- Original Message -----
From: <[EMAIL 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 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 tried
> SELECT Unique (id) as id
>
> but that did not work.
> A.
>
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
>
>
> ______________________________________________________________________
> The KCFusion.org list and website is hosted by Humankind Systems, Inc.
> List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
> To Subscribe.................... mailto:[EMAIL PROTECTED]
> To Unsubscribe................ mailto:[EMAIL PROTECTED]
>
>
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
