Correct syntax for INNER JOIN in Access SQL?

Question

There's an error in join syntax. And I can't find it at all.

<asp:AccessDataSource ID="fav_data" runat="server" DataFile="~/paperhome_data.accdb"
                                SelectCommand="INNER JOIN (SELECT * FROM [music_data] [music_junc] ON [music_d_id].[music_data]=[music_d_id].[music_junc]) WHERE ([profile_id] = 2)"></asp:AccessDataSource>
                            <SelectParameters>
                        <asp:Parameter DefaultValue="2" Name="profile_id" Type="Boolean" />
                    </SelectParameters>

Gustav · Accepted Answer · 2015-09-19 09:03:17Z

2

It's not easy to guess what you are trying to, but it could be something like this:

"SELECT * FROM [music_data] INNER JOIN [music_junc] ON [music_data].[music_d_id]=[music_junc].[music_d_id]) WHERE ([profile_id] = 2)"

It seems as you really need to read up on SQL syntax. You will get nowhere trying to write SQL in the wild.

answered Sep 19, 2015 at 9:03

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ishaan Patel Over a year ago

That did it, had to add an opening bracket after FROM. :)

Gustav Over a year ago

Oops, sorry, but try to remove the closing bracket instead.

Ishaan Patel Over a year ago

Works both ways. Interesting. :/

Collectives™ on Stack Overflow

Correct syntax for INNER JOIN in Access SQL?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related