Tuesday, 6 August 2013

SQL INNER JOIN does not see table alias

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