Yep, that nailed it.
Thanks for you time and help.
--
View this message in context:
http://postgresql.nabble.com/ERROR-missing-FROM-clause-entry-for-table-tp5886750p5887183.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgs
The call_schedule table looks like this
id| integer | not null default
nextval('call_schedule_id_seq'::regclass)
account_id| integer | not null
user_id | integer | not null
call_type_id | integer
Yes, c.start_time is a timestamp.
My goal is to list events (calls) which are scheduled on fortnightly basis.
The query works with hard coded values, but I need to generate results for
days beginning at the start_time and ending with the end_time.: eg:
2016-02-06
2016-02-07
2016-02-08 | Some acco
I am receiving this error for the query pasted below.
Is the LEFT JOIN on the table not enough?
What needs to happen here?
I am guess something to do with derived tables
http://pastie.org/10715876
--
View this message in context:
http://postgresql.nabble.com/ERROR-missing-FROM-clause-entry-for
