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
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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,
U.User_Lastname
FROM Users U
From: Rhino [EMAIL PROTECTED]
To: shaun thornburgh
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 08:22:29 -0500
- Original Message -
From: shaun thornburgh [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 21, 2005
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
[EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb
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]
Using MySQL: 4.23.46
The select query below returns a grouped list of all featured artists. Their images
are listed in a random order within each artist group.
Is it possible to still return *all* featured artists (there are 6) but only a random
selection of no greater than 2 images from
Using MySQL: 3.23.46 (Correction)
The select query below returns a grouped list of all featured artists. Their images
are listed in a random order within each artist group.
Is it possible to still return *all* featured artists (there are 6) but only a random
selection of no greater than 2