SQL : syntax error when trying to join in Access

SQL : syntax error when trying to join in Access
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

I promised to reveal a secret feature to you, and now it's time to share it.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
After that, type the word 'awesome' on your keyboard.
It will change your youtube progress bar into a flashing rainbow.

A quick introduction about me,
Welcome, I'm Delphi.
Let me aid you in resolving any queries you may have.
SQL : syntax error when trying to join in Access
Please feel free to comment or chat with me for more detailed information.
We welcome your thoughts and feedback, so please comment below with your answer or insights to the answer.
Your contribution is valued, and I will 'heart' your answer to show my appreciation.
syntax Access SQL in when to join : trying error