Access to Excel VBA SQL Join

I have two tables in a database in access and I want to perform CRUD operations from excel vba. Though I was able to perform CRUD into individual tables separately, but it says some JOIN Error while performing CRUD on both the tables at same time.Here are the
Tables &
Relationship between them.
I tried something like this but it says a JOIN Error



"Select CustomerT.First_Name,ProductT.Product_Name,CutomerT.Age From CustomerT Inner Join ProductT ON Customer.ID = ProductT.Customer_ID"


My main aim is to find out the details about the customer ans the product he/she ordered by entering the customer id.
Please suggest what to do.



Here is the full code that I am using



Sub CommandButton1_Click()

Dim con As New ADODB.Connection

Dim rs As New ADODB.Recordset

con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Access2Excel\DB1.accdb;Persist Security Info=False;"

'Open Db connection

con.Open

Set rs.ActiveConnection = con

rs.Open "Select CustomerT.First_Name,ProductT.Product_Name,CutomerT.Age From CustomerT Inner Join ProductT ON CustomerT.ID = ProductT.Customer_ID "             

StartRow = 3

Do Until rs.EOF



'first field

Cells(StartRow, 4) = rs.Fields(0).Value

'second field

Cells(StartRow, 5) = rs.Fields(1).Value

'Third field

Cells(StartRow, 6) = rs.Fields(2).Value





rs.MoveNext

StartRow = StartRow + 1

Loop

Set rs = Nothing

con.Close

Set con = Nothing

End Sub


Answers

there seems to be a T missing in Customer.ID. The join should be like:



Select CustomerT.First_Name,ProductT.Product_Name,CustomerT.Age 

From CustomerT Inner Join ProductT ON CustomerT.ID = ProductT.Customer_ID


Edit:



Also changed CutomerT.Ageto CustomerT.Age, thanks LondonRob!