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/[email protected]
