please verify my INNER JOIN statement

gilgalbiblewheel · April 2nd, 2005, 07:03 PM

What am I doing wrong in this statement?

Code:

SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE text_data LIKE '%bra%' ORDER BY id ASC

Quote:

quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

jbenson001 · April 3rd, 2005, 02:14 AM

What DB are you using?

shahchi1 · April 3rd, 2005, 07:42 AM

It looks like you are using MS Access..?

If you are using this query in ASP then response.Write(YourSqlStatement)
else check this out..

http://www.adopenstatic.com/faq/80040e10.asp

gilgalbiblewheel · April 4th, 2005, 12:34 AM

MS Access 2000.
That's the result when I response.write it:

Quote:

quote:SELECT * FROM hebbooktable INNER JOIN hebrewbibletable ON hebbooktable.book = hebrewbibletable.book WHERE text_data LIKE '%bra%' ORDER BY id ASC

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

rjweers · April 4th, 2005, 08:36 PM

It's difficult to know what's up here without the full table definitions. Typically this message means you typed the wrong name of a field or that you didn't properly delinate your criteria.

TIP: Try putting your SQL statement into the Access query builder. It will help you build the right query.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

gilgalbiblewheel · April 4th, 2005, 08:43 PM

what is an Access query builder?

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

bmains · April 5th, 2005, 07:38 AM

In the database, in the Query option, build the query there; it has an editor that can help construct the query, which is a nice feature. It would help not to use select * also, that will be better performing.

Brian