K
Kou Vang
I am able to correctly nest 2 queries into one, but am unable to successfully
get the third query to work. I do this all the time in Pass-Through, but
this is a straight Access query. So this works:
SELECT R.AUID, L.Attainment_Desc_Abbrv, R.Attainment_Desc_Abbrv
FROM
(SELECT [Assessment Table].AUID, ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ARUS) AS R
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ALUS) AS L ON
R.AUID = L.AUID
But when I try to add the 3rd query:
SELECT R.AUID, L.Attainment_Desc_Abbrv, R.Attainment_Desc_Abbrv,
C.Attainment_Desc_Abbrv
FROM
(SELECT [Assessment Table].AUID, ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ARUS) AS R
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ALUS) AS L ON
R.AUID = L.AUID
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ACUS) AS C ON
L.AUID = C.AUID
It doesn't. I know I'm improperly joining the third subquery and it's
probably something simple. Thanks.
Kou
get the third query to work. I do this all the time in Pass-Through, but
this is a straight Access query. So this works:
SELECT R.AUID, L.Attainment_Desc_Abbrv, R.Attainment_Desc_Abbrv
FROM
(SELECT [Assessment Table].AUID, ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ARUS) AS R
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ALUS) AS L ON
R.AUID = L.AUID
But when I try to add the 3rd query:
SELECT R.AUID, L.Attainment_Desc_Abbrv, R.Attainment_Desc_Abbrv,
C.Attainment_Desc_Abbrv
FROM
(SELECT [Assessment Table].AUID, ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ARUS) AS R
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ALUS) AS L ON
R.AUID = L.AUID
INNER JOIN (SELECT [Assessment Table].AUID,
ADB_Attainment_Abbrv.Attainment_Desc_Abbrv
FROM ADB_Attainment_Abbrv RIGHT JOIN [Assessment Table] ON
ADB_Attainment_Abbrv.Attainment_Desc = [Assessment Table].ACUS) AS C ON
L.AUID = C.AUID
It doesn't. I know I'm improperly joining the third subquery and it's
probably something simple. Thanks.
Kou