SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru
    Join Date
    Aug 2004
    Location
    Canada
    Posts
    730
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    please verify my INNER JOIN statement

    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
    Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
    Compare bible texts (and other tools):
    TheWheelofGod

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2005
    Posts
    74
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  3. #3
    SitePoint Enthusiast team_ecommerce's Avatar
    Join Date
    Feb 2005
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •