What's wrong with this SQL1 code?
Nevermind the "SQL1" in the title, I just tried to make it unique.
I'm trying to figure out why I keep getting an "Invalid Bracketing of
name" error for the following code. I'm sure it has to do with what is
inside the "[]", but what I'm trying to do is join a table on the ID from
both tables and compare it to the stored ID (@ID).
SelectCommand="SELECT * FROM [Table2] INNER JOIN BlogEntryItems WHERE
([Table2.ID = BlogEntryItem.ID] = @ID)"
This is what it looked like before I tried to do the join:
SelectCommand="SELECT * FROM [Table2] WHERE ([ID] = @ID)"
I'm sure there is someone out there who can help.
No comments:
Post a Comment