try SELECT Test2.* FROM test2 inner join test11 ON test2.id=test11.id
ORDER By Name;
Will Leshner a �crit :
I guess I never really noticed this before (since I only use SQLite,
of course :) ). But consider a query like this:
SELECT test2.* FROM test2,test11 WHERE test2.id=test11.id ORDER BY name
If the 'name' column happens to be a column in both test2 and test11,
then SQLite will return an error. You need to qualify 'name' with
'test2.' to make the query acceptable. Apparently MySQL and
PostgreSQL are able to recognize that 'name' refers to the 'name' in
the result set and are able to disambiguate it.
