On Jul 18, 2007, at 16:12 , Pat Maddox wrote:
ERROR: invalid reference to FROM-clause entry for table "video_views"
LINE 20: JOIN assets ON (video_views.video_id=videos.id)
^
HINT: There is an entry for table "video_views", but it cannot be
referenced from this part of the query.
It's because I mismatched the JOIN clauses during my copy-and-paste :(
On 7/18/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote:
FROM video_views
JOIN assets ON (video_views.video_id=videos.id)
JOIN videos ON (video_views.asset_id=assets.id)
This should be
FROM video_views
JOIN assets ON (video_views.asset_id=assets.id)
JOIN videos ON (video_views.video_id=videos.id)
Do you have the EXPLAIN ANALYE output of the query?
Michael Glaesemann
grzm seespotcode net
