HELP FOR SELECT QUERY!

[Roberto Esposito]

HI to All....
i need an help for a Select Query
MYSQL Version 3.23.58

it's all day i try to resolve this problem.... but i don't find SOLUTION!
sigh :-(

This is the simple query.....
SELECT DISTINCT id_sch_travel, departure, price, day, night
FROM `date_viaggi`
WHERE last_minute=1
(database contains id, id_sch_travel, departure, price, day, night, online,
id_airport, ecc ecc)
Now, this query is corrected and works!

from this query i extract all i need, because DISTINCT give me filtered
line...

but i need id, and if i ADD id on that query DISTINCT is useless!

GROUP BY don't filter my correct because i need all date for single
id_sch_travel BUT Only 1 Date every day for id_sch_travel, and there is more
date for day because there is many Departures Airport.
now i need or

Group by id_airport for every day on every id_sch_travel.... but is
impossible!

or ID on DISTINCT id_sch_travel, departure, price, day, night
....style...

SELECT id DISTINCT id_sch_travel, departure, price, day, night
FROM `date_viaggi`
where last_minute=1

ehehe but this query is mismatch eheheh :-P

Release 3.23.58 don't support subquery...
Anyone have Idea ??

Excuse for my bad english.. i'm italian!

Thanks!!
Roby

[Stephen]

Your distinct field must be selected first. All others come after it.

like this :
SELECT DISTINCT id_sch_travel, id, departure, price, day, night
FROM `date_viaggi`
where last_minute=1

****
Stephen Johnson
http://www.thelonecoder.com