vhats wrong with my query [subqueries ITT]
Posted: Tue Jul 13, 2010 2:37 pm
Code: Select all
SELECT id,effortid,productid,
(SELECT interval FROM auto_schedules_intervals WHERE scheduleid=auto_schedules.id) AS interval,
(SELECT description FROM templates WHERE id=auto_schedules_intervals.templateid) AS template
FROM auto_schedules
WHERE productid={$_SESSION['renewals_pub']};
help!ERROR: missing FROM-clause entry for table "auto_schedules_intervals"
LINE 1: ...rval, (SELECT description FROM templates WHERE id=auto_sched...