KB Issue

When creating JOIN Statements within SQL Server, when copied out and placed in your project, you might inadvertently erase a letter from part of the statement.

Issue Details

When you create the SQL Query within SQL Server, and then copy it out into your project, you might inadvertently remove one of the letters when you are fixing the code to properly run within your ASP Classic or ASP.NET page.
In that case, you will receive the following error.

Microsoft OLE DB Provider for SQL Server error '80040e14'
'JOI' is not a recognized join option.
/About.asp, line 49

Recreate IssueTo recreate this issue.

The following is SQL Server-generated code.

Code Example


SELECT TOP (20) Categories.CatName, SubCategories.SCID
FROM Categories INNER JOI
SubCategories ON Categories.MCID = SubCategories.MCID

Looking at the code, on line #2, you can see the INNER JOI

Copy

Search Site

Search Google

; however, it is missing the N

Copy

Search Site

Search Google

of JOIN

Copy

Search Site

Search Google

.

Resolve Issue

Add the N

Copy

Search Site

Search Google

to the end of the JOI to complete the word

Code Example

SELECT TOP (20) Categories.CatName, SubCategories.SCID 
FROM Categories INNER JOIN 
SubCategories ON Categories.MCID = SubCategories.MCID

The code will look like this when added to your ASP Classic or ASP.NET page.

Code Example


sql.commandtext="SELECT TOP (20) Categories.CatName, SubCategories.SCID FROM Categories INNER JOIN SubCategories ON Categories.MCID = SubCategories.MCID"