XDefender
Дата: 06.05.2002 13:04:18
SELECT *, (SELECT F+' '+I FROM Members WHERE Members.ID=SchoolMembers.Member_id) as Name,
(SELECT MAX(Date) FROM AdviceToSpeeches WHERE AdviceToSpeeches.member_id=SchoolMembers.Member_id)
as LastDate
FROM SchoolMembers
WHERE Reci Like '%1%'
ORDER BY LastDate - ????