Prev: Query for a report
Next: Sorting does not distinguish bet ween Œ and OE or Æ and AE
From: Kou Vang on 26 Feb 2010 14:23
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
 | 
Pages: 1
Prev: Query for a report
Next: Sorting does not distinguish bet ween Œ and OE or Æ and AE