Citat:
upit mi pravi problem jer neke stavke iz tablice a izostavi, a nisam mogao dokuciti koja..mislim zbog cega mi ih izostavlja...
ideju nemam sta pokusavas da uradis ali ti ovo mozda pomogne (iz drugog posta):
Code:
mysql> SELECT k1.friendid, k2.friendid, k3.friendid FROM (SELECT t_friend.friendid FROM t_friend WHERE t_friend.userid=1) k1 JOIN t_friend k2 ON (k2.userid = k1.friendid) JOIN t_friend k3 ON (k3.userid = k2.friendid);
+----------+----------+----------+
| friendid | friendid | friendid |
+----------+----------+----------+
| 2 | 3 | 4 |
| 2 | 3 | 7 |
+----------+----------+----------+
2 rows in set (0.00 sec)
mysql> SELECT k1.friendid, k2.friendid, k3.friendid FROM (SELECT t_friend.friendid FROM t_friend WHERE t_friend.userid=1) k1 LEFT JOIN t_friend k2 ON (k2.userid = k1.friendid) LEFT JOIN t_friend k3 ON (k3.userid = k2.friendid);
+----------+----------+----------+
| friendid | friendid | friendid |
+----------+----------+----------+
| 2 | 3 | 4 |
| 2 | 3 | 7 |
| 2 | 5 | NULL |
| 2 | 6 | NULL |
| 3 | 4 | NULL |
| 3 | 7 | NULL |
| 5 | NULL | NULL |
+----------+----------+----------+
7 rows in set (0.00 sec)
dakle obrati paznju izmedju standardnog (inner) join-a i LEFT jon-a gde ti u slucaju LEFT join-a upit vraca i vrednosti gde u drugoj tabeli nemas vrednost.