Forum » Programiranje » MYSQL in PRESEK(intersect)
MYSQL in PRESEK(intersect)
nejcpirc ::
Pozdravljeni
Uporabljam MySql server 4.1 in MySql Query browser 1.1.4.
Zakaj mi u Query browzerju ne deluje ukaz INTERSECT (presek)?
primer naloge:
(SELECT distinct ime from OSEBE where starost>'22' )
intersect
(SELECT distinct ime from OSEBE where status='1');
ERROR:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intersect
(select distinct ime from OSEBE where' at line 2
Če uporabljam ukaz UNION mi deluje brez erorjev....
LP, Nejc
Uporabljam MySql server 4.1 in MySql Query browser 1.1.4.
Zakaj mi u Query browzerju ne deluje ukaz INTERSECT (presek)?
primer naloge:
(SELECT distinct ime from OSEBE where starost>'22' )
intersect
(SELECT distinct ime from OSEBE where status='1');
ERROR:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intersect
(select distinct ime from OSEBE where' at line 2
Če uporabljam ukaz UNION mi deluje brez erorjev....
LP, Nejc
darh ::
A samo v mysqlquery browserju to javi? Kaj pa če direktno pošlješ ukaz srverju (oz. je to najbrž brezveze če query-browser dela ravno to...)?
Excuses are useless! Results are priceless!
Vredno ogleda ...
| Tema | Ogledi | Zadnje sporočilo | |
|---|---|---|---|
| Tema | Ogledi | Zadnje sporočilo | |
| » | MS Access (strani: 1 2 )Oddelek: Programiranje | 7453 (5511) | travica |
| » | SQL-DML pomočOddelek: Programiranje | 1007 (830) | JackCola |
| » | SQL poizvedbaOddelek: Programiranje | 1485 (1247) | xsenon |
| » | SQL poizvedba z DISTINCTOddelek: Programiranje | 1924 (1765) | zdravc |
| » | [mysql] malo bolj zahtevna poizvedbaOddelek: Programiranje | 1602 (1453) | destiny |