Here is the query i was able to build in sql server ....i wanted an equivalent access syntax...tried everthing but nothing seems to work...it is a urgent need at my work and i need the help....
SELECT A.ID,A.Name,
CASE WHEN A.SAL = ( SELECTDISTINCT SAL2 FROM (...