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 | 8029 (6087) | travica |
| » | SQL-DML pomočOddelek: Programiranje | 1114 (937) | JackCola |
| » | SQL poizvedbaOddelek: Programiranje | 1590 (1352) | xsenon |
| » | SQL poizvedba z DISTINCTOddelek: Programiranje | 2065 (1906) | zdravc |
| » | [mysql] malo bolj zahtevna poizvedbaOddelek: Programiranje | 1721 (1572) | destiny |