PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
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']};
ERROR: missing FROM-clause entry for table "auto_schedules_intervals"
LINE 1: ...rval, (SELECT description FROM templates WHERE id=auto_sched...
help!
Last edited by bla5e on Tue Jul 13, 2010 4:07 pm, edited 1 time in total.
SELECT id, effortid, productid,
(SELECT interval FROM auto_schedules_intervals WHERE scheduleid=auto_schedules.id) AS interval
FROM auto_schedules
WHERE productid={$_SESSION['renewals_pub']}
is working, but i need the description from the templates table too!