shaun thornburgh schrieb:
> Thanks for your reply, I would like the query to retun one
> instance of user 101 rather than 15!
SELECT DISTINCT ...
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
from the first table
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 13:24:55 +
From: "Rhino" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[
From: "Rhino" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[EMAIL PROTECTED]>,
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 08:22:29 -0500
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Monday
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 21, 2005 7:28 AM
Subject: Help with a query please
> Hi,
>
> I am having trouble with the following query:
>
> SELECT U.User_ID,
> U.User_Firstname
Hi,
I am having trouble with the following query:
SELECT U.User_ID,
U.User_Firstname,
U.User_Lastname
FROM Users U, Allocations A
WHERE (U.User_ID = A.User_ID OR U.User_ID = 101)
AND A.Project_ID = '12'
AND ( U.User_Type = 'Staff'
OR U.User_Type = 'Manager'
OR U.User_Type = 'Administrator' )
ORDER
