Subselects ?

[SteveBamford]

Hello, can anyone tell me if subselects are allowed in MySQL - i am trying to do something like ...

SELECT file_name,
access_timestamp,
(SELECT max(access_timestamp)
FROM web_page_visitors w2
WHERE w2.file_name = w1.file_name)
FROM web_page_visitors w1
WHERE access_timestamp >= (now() - INTERVAL 1 DAY )

thanks

steve

[r937]

yes, in 4.1

[r937]

prior to 4.1, try this:

select w1.file_name
     , w1.access_timestamp
     , max(w2.access_timestamp)
  from web_page_visitors w1
left outer
  join web_page_visitors w2
    on w1.file_name 
     = w2.file_name
 where w1.access_timestamp 
    >= date_add(now(), interval -1 day ) 
group
    by w1.file_name
     , w1.access_timestamp

[SteveBamford]

Thanks for the help all

i did it using a join - no worries !

steve