CoolTShirt Project

I just finished the CoolTShirt project here [] But my final query wasnt running and i couldnt figure out the reason why

I am a newbie, but on a quick look, I see as follows… I do not thing you can include the WHERE clause before ON… I do think that ON should immediately follow JOIN:

FROM page_visits pv
JOIN last_touch lt
ON pv.user_id = lt.user_id
AND pv.timestamp = lt.last_touch_at
WHERE page_name = '4 - purchase'

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.