select u dve tabele sa inner join ...Dakle,
čitao sam mnogo o ovome i da li sam malko priglup post'o ili je to posledica čitanja u ove sitne sate nakon celodnevnog rada, ko to zna...
Elem, preblem mi je sledeći:
Code:
Table: names
+----+----------+--------+
| id | name | code |
+----+----------+--------+
| 1 | Pera | 21 |
| 2 | Mika | 35 |
+----+----------+--------+
Table: years
+----+----------+--------+
| id | year | code |
+----+----------+--------+
| 8 | 1971 | 28 |
| 9 | 1975 | 21 |
+----+----------+--------+
Table: names
+----+----------+--------+
| id | name | code |
+----+----------+--------+
| 1 | Pera | 21 |
| 2 | Mika | 35 |
+----+----------+--------+
Table: years
+----+----------+--------+
| id | year | code |
+----+----------+--------+
| 8 | 1971 | 28 |
| 9 | 1975 | 21 |
+----+----------+--------+
treba mi ekvivalent sledećeg query-ja:
SELECT code FROM names WHERE name='Pera' INTERSECT SELECT code FROM years WHERE year > 1974
Ovaj upit bi trebao da vrati rezultat 21.
Kako ovo napisati sa nekim od JOIN-a?
