SQL INNER JOIN does not see table alias
I'm having trouble with this SQL statement:
SELECT linkstable.date, (linkstable.count - x.count) FROM (SELECT .....)
AS linkstable INNER JOIN linkstable AS x ON linkstable.date = x.date+1
It tells me that links table cannot be found although (SQL error 1146)
there clearly is an alias to that select query. Can anybody tell me please
how do I bypass this error?
No comments:
Post a Comment