I have no idea what I was thinking. For some reason I was thinking
Distinct wouldn't work, must have been temporarily brain dead. Thanks
for the wake up call.
Gerald L. Clark wrote:
Chris W wrote:
I have two tables, one is a list of users and the other is a list of
events for each user. It is a one to many relationship. The event
table is pretty simple just an event type and a the date and time of
the event in a datetime field.
I need a query that shows all events of a certain type for each user,
very simple so far. In fact the query I use now is simply,
SELECT u.FName, u.LName, e.EventType, DATE(e.DateTime)
FROM user u
JOIN event e USING(UserID)
ORDER BY u.LName, u.FName, e.EventType, e.DateTime
The twist comes in that there can be several records for a given user
and event type all on the same day, in a case like that, I only want
the query to show one record. So I need one record per user per
event type per day. The query will strip the time part off of the
date time field and only display the date. We don't really care if
that event happened 1 or 10 times in one day just that it happened at
least once on that day for a user.
Chris W
try DISTINCT.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]