SELECT
 n1,
 n2,
 n3
 FROM aaaaa
 WHERE
 (a1=a2)
 and
 (b1=b2)
 and
 (c1=c2)
 ORDER BY n1,
 n2,
 n3;

Add(MainForm,2953706,203,56)
{
 Width=260
 Height=298
 Position=1
}
Add(Memo,12633949,259,56)
{
 Width=244
 Height=259
 Align=5
 Font=[Lucida Sans Typewriter,12,0,0,0]
 Strings=#87:SELECT n1, n2, n3 FROM aaaaa WHERE (a1=a2) and (b1=b2) and (c1=c2) ORDER BY n1, n2, n3;|
 ScrollBars=2
}

SELECT  employees.employee_id,employees.last_name,positions.title
 FROM employees
 INNER JOIN positions
 ON employees.employee_id = positions.employee_id
 ORDER BY positions.title;