ORDER

[FairPrice]

How can you do it using the handler
SELECT t.name, p.suma FROM tovar t, price p WHERE t.id=2 ORDER BY p.suma DESC

[nijikon]

What's the output of this query?

[FairPrice]

Bring the record is initially sorted

[iperevozchikov]

HandlerSocket (HS) technology not support multiquering such as any possible JOIN or SELECT FROM multiple tables.
For correctly use HS you must split your query to N single queries.
In your situation you can use as:

1. SELECT name FROM tovar WHERE id=2;
2. SELECT suma FROM price WHERE id < {BIG_INT} AND tovar_id = {id};

PS. Construction like key < {BIG_INT} - will be ORDER rows in DESC direction and of course > {BIG_INT} will be ORDER ASC.