none
MS Access SQL Query Issue - Inner Joins RRS feed

All replies

  • 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)

    Saturday, August 25, 2018 7:23 AM