PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
Reports & Queries
→
ORDER et UNION ?
ORDER et UNION ?
Started by Saturnin, Aug., 24 2007 9:14 AM - 1 reply
Connect yourself…
Saturnin
#1
Posted on August, 24 2007 - 9:14 AM
En SQL, il est possible de faire :
SELECT DateFin,DateDébut
FROM Séjour
WHERE datefin = ""
Order by dateDébut
UNION
SELECT DateFin,DateDébut
FROM Séjour
WHERE datefin <> ""
Order by datefin DESC
hors en windev, si je met un union apres un ORDER, j'ai un message d'erreur "Mot UNION inatendu". Ce message disparait si j'enleve l'order.
Je me trompe quelquepart ?
merci d'avance.
Report
0
0
serge
#2
Posted on August, 24 2007 - 11:29 AM
Refaite la requête avec l'éditeur de requête de windev et vous verrez l'équivalent de celle-ci
Report
0
0
→ Go back to Reports & Queries
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
WEBDEV (earlier versions)
WINDEV Mobile (earlier versions)
Reports & Queries
Off-topic
Tools
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text