problem is tho were i have put 1 2 3 and z there jus examples the actual data is completely different and would be impossible for me to do the...

aims

i cant create just query 🙁

hi thanks for your efforts but i cannot drop the tables is there a way of doing it without altering any of the tables

Tis done boys thanks for all your help

HI thanks for your help but it came up with an error

incorrect syntax near the keyword 'group'

highlights groub by l01, l03

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...

SUCCESS Thanks for all your help Guys And Girls its worked Thanks again

thanks for your help david but this doesnt take the null values into account

this is not taking null values into account my friend

what does the &gt mean

Basically the table looks like this

learner a b c

mam ...

i havent need help please not sure how to go about it never used sql in my life