When I perform the following select statement, I get an error that says Unknown table 'photo' in where clause. Any ideas? This problem just popped up, it was working before. The only thing that changed was we made the mysql upgrade to v 4.01.
Let me know, thanks.
Select Statement:
SELECT DISTINCT stories.story_id, DATE_FORMAT(stories.pub_date, '%Y %m-%d'), stories.pub_id, stories.section_id, stories.page, stories.series, stories.keyword_id, stories.byline, stories.headline, stories.intro, stories.bodytext, stories.correction, stories.correction_date, stories.label FROM stories,photo WHERe stories.pub_date BETWEEN '2003-01-01' AND '2025-12-31' AND match(photo.photo_credit) AGAINST('zugs' in boolean mode) AND stories.story_id = photo.story_id ORDER BY stories.pub_date DESC limit 0,10
