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