Dear All,  How to convert the SQL from MSSQL to Access as following:SELECT Organization.Name, Organization.Id AS OrganizationID, Item.Id as Itemid, Item.CTitle, Item.Title,AcceptList.*FROM OrganizationCROSS JOIN ItemLEFT JOIN (  SELECT S.OrganizationID, en.ItemID  FROM Event S, Program en  WHERE en.EventID = s.Id  AND en.Accepted = 1  GROUP BY S.OrganizationID, en.ItemID  ) AcceptList ON AcceptList.OrganizationID = Organization.Id                and AcceptList.ItemID = Item.Idwhere AcceptList.ItemID is null