Группировка в запросе

SELECT card.id_card, card.inv, equipment.name_equip, card.cost, card.delivery_date, card.writeoff_date, subdivision.name_subdiv, (SELECT MAX(movement.date_m) FROM movement WHERE  card.id_card = movement.id_card) AS last_date
FROM subdivision RIGHT JOIN (equipment RIGHT JOIN (event RIGHT JOIN (card INNER JOIN movement ON card.id_card = movement.[id_card]) ON event.id_event = movement.event) ON equipment.id_equip = card.id_equip) ON (subdivision.id_subdiv = movement.for_m)
WHERE (((movement.event)<>2));

SELECT 
card.id_card,
card.inv,
equipment.name_equip, 
card.cost, 
card.delivery_date, 
card.writeoff_date, 
subdivision.name_subdiv,
movement.date_m
FROM subdivision 
RIGHT JOIN (event 
RIGHT JOIN (equipment 
RIGHT JOIN (card 
INNER JOIN movement 
ON card.id_card=movement.id_card) 
ON equipment.id_equip=card.id_equip) 
ON event.id_event=movement.event) 
ON subdivision.id_subdiv=movement.for_m
WHERE (((movement.event)<>2))
ORDER BY card.id_card

SELECT 
card.id_card, 
LAST(card.inv) AS [Last-inv], 
LAST(equipment.name_equip) AS [Last-name_equip], 
LAST(card.cost) AS [Last-cost], 
LAST(card.delivery_date) AS [Last-delivery_date], 
LAST(card.writeoff_date) AS [Last-writeoff_date], 
LAST(SELECT TOP 1 subdivision.name_subdiv 
FROM subdivision, movement,event 
WHERE subdivision.id_subdiv=movement.for_m 
AND movement.id_card=card.id_card 
AND event.id_event<>2 
AND movement.date_m=
(SELECT MAX(movement.date_m) 
FROM movement 
WHERE movement.id_card=card.id_card)) AS [Last-name_subdiv],
MAX(date_m) AS [Last-date_m]
FROM subdivision 
RIGHT JOIN (event 
RIGHT JOIN (equipment 
RIGHT JOIN (card 
INNER JOIN movement 
ON card.id_card=movement.id_card) 
ON equipment.id_equip=card.id_equip) 
ON event.id_event=movement.event) 
ON subdivision.id_subdiv=movement.for_m
WHERE (((movement.event)<>2))
GROUP BY card.id_card
ORDER BY card.id_card;

SELECT m.id_card, m.date_m, m.subdivision
FROM movement m, (SELECT id_card, MAX(date_m) AS mx FROM movement GROUP BY id_card) q,
m INNER JOIN q ON m.id_card=q.id_card AND m.date_m=q.mx
WHERE m.event <> 2