Topic: Request in MySQL: the basic delirium?
Just in case I want to specify.
SELECT... WHERE ... AND fld1 = (SELECT id FROM tbl WHERE... ORDER BY fld2 ASC)
If the field (fld1) is compared with SELECT' it is expected, what SELECT returns strictly single line, and to sort it BY fld2 without instructions LIMIT of sense any is not present? Or suddenly is?