First, sorry my starnge way to post new thread. Second: I want to specify some features: in my table notes I've a lot of user_id's for each object_id and I don't want to find unique user_id, I only want to find one user_id for each object_id, so unique(user_id) doesn't match. Do u have any other ideas?
Mike U. Petrov
-----Original Message----- From: Justin Patrin [mailto:papercrane@xxxxxxxxxxxxxxx] Sent: Thursday, December 11, 2003 10:53 AM To: php-db@xxxxxxxxxxxxx Subject: Re: Very complex query
Use unique(user_id). And please don't reply to a previous post when posting a new thread....it screws up threading.
-- paperCrane <Justin Patrin>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Oops, sorry about that. What you could do is:
GROUP BY object_id
or
GROUP BY object_id, other_field, other_field2, etc
Just don't group by user_id.
-- paperCrane <Justin Patrin>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
