my ISP is using mysql v4.0.26 I am trying to do the following SQL and cannot
get it to parse without an #1064 error.
select r.prog_id, r.prog_name, p.show_id, p.show_title, p.show_desc,
p.show_speaker, p.show_date_recorded, s.spk_name
from programmes p, series r, speaker s
where r.prog_id =
Rob - sub-selects aren't supported prior to version 4.1.
This page may be of some assistance:
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html
Have you tried using a MAX(p.show_date_recorded) and appropriate GROUP BY ?
Dan
On 9/22/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: