Welcome! Log In Create A New Profile

Advanced

Access 2000 and inner joins

Posted by Howie 
Announcements Last Post
Announcement myUnisa availability 21 to 24 March 2019 03/17/2019 02:24PM
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Access 2000 and inner joins
May 06, 2007 12:52PM
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"winking smiley. Is this because inner joins are not supported in access 2000 or a mistake in the sql code above that I cannot see?
Anonymous User
Re: Access 2000 and inner joins
May 06, 2007 02:00PM
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]
Re: Access 2000 and inner joins
May 06, 2007 03:28PM
Thanks Rick, did not see that comma, feel like a bit of a twit at the moment. confused smiley
Anonymous User
Re: Access 2000 and inner joins
May 06, 2007 05:01PM
Don't. I did this module last year. Hang in there.
Sorry, only registered users may post in this forum.

Click here to login