It should look something like below. I did change the FROM to tbl_Licenties because I think it makes more sense to start from that table.
I do have a question. I gave you a detailed description (in the other topic) how you could convert a MS Access SQL statement (with all the extra nestings) to a proper SQL-statement. Wasn't that description clear? If so... what was not clear? I would like to know so we can teach you how to convert these statements yourself (without you having to ask us). Did you try it yourself using my description, and if so, where did you have trouble? (please don't see this remark as criticism)
Also you original query could never work in MS Access because you don't have a space before the FROM. See here:
'tbl_Seizoenen.SEI_Periode' + 'FROM '
This will result in
tbl_Seizoenen.SEI_PeriodeFROM
which is not valid SQL.
(I changed the inttostr(ID) to 2222 to show you the "clean" SQL here)
SELECT
tbl_Licenties.Fluit_ID,
tbl_Licenties.Fluit_Scheids_ID,
tbl_Licenties.Fluit_Seizoen_ID,
tbl_Licenties.Fluit_Licentie_ID,
REPLACE(RTRIM(COALESCE(Voornaam || " ", "") || COALESCE(Tussenvoegsel || " ", "") || COALESCE(Achternaam, "")), " ", " ") AS Scheidsrechter,
tbl_Licenties_Keuze.Licentie,
tbl_Seizoenen.SEI_Periode
FROM tbl_Licenties
INNER JOIN tbl_Licenties_Keuze ON tbl_Licenties.Fluit_Licentie_ID = tbl_Licenties_Keuze.Licentie_ID
INNER JOIN tbl_Scheidsrechters ON tbl_Licenties.Fluit_Scheids_ID = tbl_Scheidsrechters.Scheids_ID
INNER JOIN tbl_Seizoenen ON tbl_Licenties.Fluit_Seizoen_ID = tbl_Seizoenen.SEI_ID
WHERE tbl_Licenties.Fluit_Scheids_ID<>19 AND tbl_Licenties.Fluit_Scheids_ID=2222
ORDER BY REPLACE(RTRIM(COALESCE(Voornaam || " ", "") || COALESCE(Tussenvoegsel || " ", "") || COALESCE(Achternaam, "")), " ", " "),
tbl_Seizoenen.SEI_Periode DESC;