I've an Access Frontend with an Access Backend. I now want to change
to a MySQL-backend and I've got problems with ORDER BY.
This is the SQL-query I'm using:
SELECT DISTINCTROW teile.teil_nr, teile.bez_1, lieferan.name,
lieferan_lief_nr
FROM teile, lieferan
WHERE teile.lief_nr = lieferan.lief_nr
ORDER BY teile.teil_nr
If I use this SQL-query in an SQL-Pass Through query it is working fine.
But if I use this SQL-string in an Access-query (through linked tables) the
returned
table is always sorted by lieferan.lief_nr and I can't change the order the
table is
sorted.
Well, the problem is solved if you say: "Use the SQL-Pass Through-query",
but my
frontend is quite big and I want to avoid to change the whole thing.
I'm using mysql 3.22.24-debug for Win32 and Access97 on Win95.
Didn't find my problem in the manual.
tnx, Robert
4 messages in com.mysql.lists.win32Order By works only with Pass-Through
