Andrea Giammarchi wrote:
However I've tried to leave mydate search and compare just city_ext and number_ext .... these two table are very slow with a simple match of one id .
Any new ideas ?
I would try something like that....
SELECT
date_ext.mydate as MyDate,
city_ext.city as MyCity,
number_ext.mynum as MyNumber
FROM number_ext JOIN city_ext ON number_ext.city = city_ext.id JOIN date_ext ON number_ext.mydate = date_ext.id
WHERE
date_ext.mydate = ( SELECT MAX( date_ext.mydate ) FROM date_ext )
ORDER BY
city_ext.city,
number_ext.position
I think that the tables schema and the dump of some data could be usefull...
Paolo
