MS Access SQL Query Issue - Inner Joins

Question

.....

Answer 1

Does this work?

SELECT PFC_RD_3Level_Flat_Expanded.[Compound Code] as Code
, New_PFC_Request.N_Alias
, New_PFC_Request.N_Parent_Mode
, UserInfo.Name
, UserInfo.[Work Email]
, New_PFC_Request.Modified
, New_PFC_Request.Request_Status
FROM (New_PFC_Request INNER JOIN PFC_RD_3Level_Flat_Expanded ON New_PFC_Request.N_Alias = PFC_RD_3Level_Flat_Expanded.[Compound Alias]) INNER JOIN UserInfo ON New_PFC_Request.[Created By] = UserInfo.ID
WHERE New_PFC_Request.Request_Status = 'Completed' OR  New_PFC_Request.Request_Status = 'Rejected';

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)