Access 2000 and inner joins

On writing

SELECT a.fruit,
a.f_num,
b.c_num,
b.color
FROM sec1306_fruits a,
INNER JOIN sec1306_colors b
ON a.f_num = b.c_num
ORDER BY a.fruit;


from pg 548 of the book in access 2000, I get an error("Syntax error in FROM clause". Is this because inner joins are not supported in access 2000 or a mistake in the sql code above that I cannot see?

I think there's a grammar error that crept in. Try the sql without the comma at the end of line 5. i.e.

SELECT a.fruit,
a.f_num,
b.c_num,
b.color
FROM sec1306_fruits a
INNER JOIN sec1306_colors b
ON a.f_num = b.c_num
ORDER BY a.fruit;

The statement above is modeled on the statement below. The syntax structure was pulled from http://www.w3schools.com/sql/sql_join.asp

SELECT field1, field2, field3
FROM first_table
INNER JOIN second_table
ON first_table.keyfield = second_table.foreign_keyfield

[then you can order your result]

Thanks Rick, did not see that comma, feel like a bit of a twit at the moment.

Don't. I did this module last year. Hang in there.