(ovaj deo si ti trebao da napises:)
Code:
mysql> create table t1 (id int, id1 int, id2 int) engine=myisam;
Query OK, 0 rows affected (0.01 sec)
mysql> insert into t1 values (1,3,5), (2,4,6);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> create table t2 (id int, opis char(10)) engine=myisam;
Query OK, 0 rows affected (0.03 sec)
mysql> insert into t2 values (1, 's1'), (2, 's2'), (3, 's3'), (4, 's4'), (5, 's5'), (6, 's6');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
i onda upit:
Code:
mysql> select (select opis from t2 where t2.id = t1.id) as opis, (select opis from t2 where t2.id = t1.id1) as opis1, (select opis from t2 where t2.id = t1.id2) as opis2 from t1;
+------+-------+-------+
| opis | opis1 | opis2 |
+------+-------+-------+
| s1 | s3 | s5 |
| s2 | s4 | s6 |
+------+-------+-------+
2 rows in set (0.01 sec)