please verify my INNER JOIN statement

[gilgalbiblewheel]

What am I doing wrong in this statement?

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

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

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

[bslintx]

that error usually indicates a field is mispelled....

use ms access query analyzer to create the inner join for you and go to sql view to cut and paste the code...also,,,no need for asc...that's a default in order by

good luck

[team_ecommerce]

Assuming book, text_data and id are columns in hebbooktable and book is also a column in hebrewbibletable:

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