hi mate

basically this part of the query

SELECT A.L01, A.L03, A.L39, B.A04, B.A10, B.A31

FROM [LEARNER_SN05]AS A

INNER JOIN (SELECT L01, L03, A04, A10, A31

FROM [AIMS_SN05]

WHERE A04 <> 35

AND A10 IN (10, 22, 81)

AND A31 IS NOT NULL

GROUP BY L01, L03, A04, A10, A31) AS B ON B.L01 = A.L01 AND B.L03 = A.L03

WHERE A.L39 = 95

GROUP BY A.L01, A.L03, A.L39, B.A04, B.A10, B.A31

gives me this

L01 L03 L39 A04 A10 A31

1 123 95 10 22 01/09/1990

1 234 95 22 22 02/09/1990

2 345 95 32 10 03/09/1990

3 456 95 45 81 19/09/2012

4 567 95 10 22 10/10/2012

4 567 95 10 22 15/10/2012

5 678 95 11 81 01/09/1990

and i want to show the number of l03 that are duplicates so in this case 567 record shows up twice