mysql> select * from saradnici;
+-------+----------+---------+
| sifrs | napomena | nadimak |
+-------+----------+---------+
| 1 | NULL | djole |
| 2 | NULL | mika |
| 3 | NULL | pera |
| 4 | NULL | zika |
+-------+----------+---------+
4 rows in set (0.06 sec)
mysql> select sifrpo from ponude;
+---------+
| sifrpo |
+---------+
| 23 |
| 111 |
| 5643 |
| 3455532 |
| 3455533 |
| 3455534 |
| 3455535 |
| 3455536 |
| 3455537 |
| 3455538 |
| 3455539 |
| 3455540 |
| 3455541 |
| 3455542 |
| 3455547 |
| 3455548 |
| 3455549 |
| 3455550 |
| 3455551 |
| 3455552 |
| 3455553 |
| 3455554 |
| 3455555 |
| 3455556 |
| 3455557 |
| 3455558 |
| 3455559 |
| 3455560 |
+---------+
28 rows in set (0.07 sec)
mysql> select * from strani_ucesnici;
+--------+----------+
| ponuda | saradnik |
+--------+----------+
| 23 | 1 |
| 23 | 2 |
| 111 | 2 |
| 23 | 3 |
+--------+----------+
4 rows in set (0.00 sec)
mysql> select sifrs from saradnici
left outer join strani_ucesnici on saradnici.sifrs=strani_ucesnici.saradnik and strani_ucesnici.ponuda='23'
where strani_ucesnici.saradnik=NULL;
Empty set (0.02 sec)
[Ovu poruku je menjao konj dana 11.01.2006. u 16:58 GMT+1]