hey... got a quick situation where i'm trying to figure out how to do a unique/distinct so i get "two" (2) rows for the 'faculty_id'...
so.. how can i get just two unique/distinct rows based on the faculty_id.... thanks mysql> select distinct f1_status.faculty_id, c1.cname, course1.cname, f1_status.userID, c1.id, f1_status.id -> from c1 -> join d1 -> on c1.id=d1.cID -> join course1 -> on d1.id=course1.dID -> join f1_status -> on course1.fID=f1_status.faculty_id -> where c1.id=1 and d1.id=1; +------------+-------+-------------+--------+----+----+ | faculty_id | cname | cname | userID | id | id | +------------+-------+-------------+--------+----+----+ | 1 | usc | math-101 | 1 | 1 | 1 | | 2 | usc | math-202 | 2 | 1 | 2 | | 1 | usc | physics-101 | 1 | 1 | 1 | +------------+-------+-------------+--------+----+----+ 3 rows in set (0.00 sec) ============================================================== mysql> select c1.cname, course1.cname, f1_status.faculty_id, f1_status.userID, c1.id, f1_status.id -> from c1 -> join d1 -> on c1.id=d1.cID -> join course1 -> on d1.id=course1.dID -> join f1_status -> on course1.fID=f1_status.faculty_id -> where c1.id=1 and d1.id=1; +-------+-------------+------------+--------+----+----+ | cname | cname | faculty_id | userID | id | id | +-------+-------------+------------+--------+----+----+ | usc | math-101 | 1 | 1 | 1 | 1 | | usc | math-202 | 2 | 2 | 1 | 2 | | usc | physics-101 | 1 | 1 | 1 | 1 | +-------+-------------+------------+--------+----+----+ 3 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org