locked
INNER JOIN string that works in MDB, but gives me an error in ACCDB. RRS feed

  • Question

  • User-45359601 posted

    I have an INNER JOIN string that works in MDB, but gives me an error in ACCDB.

    SELECT ArchiveCatalogues.DATE, ArchiveCatalogues.AUCTION AS ArchiveCatalogues_AUCTION, ArchiveCatalogues.LOT, ArchiveCatalogues.PUBEST2, ArchiveCatalogues.IMAGE, ArchiveCatalogues.FIRSTNAME, ArchiveCatalogues.ARTIST, ArchiveCatalogues.SUFFIX, ArchiveCatalogues.TITLE,  ArchiveCatalogues.FRONTPAGE, ArchiveDates.Current, ArchiveDates.Auction AS ArchiveDates_Auction
    FROM ArchiveCatalogues INNER JOIN ArchiveDates ON ArchiveCatalogues.AUCTION = ArchiveDates.Auction
    WHERE ArchiveDates.Current = MMcurrent AND ArchiveCatalogues.FRONTPAGE = '1'

    Any ideas?

     

    Thursday, March 10, 2011 7:07 AM

Answers

  • User1867929564 posted

    http://forums.asp.net/p/1661976/4338569.aspx/1?Re+INNER+JOIN+string+that+works+in+MDB+but+gives+me+an+error+in+MS+SQL+

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 14, 2011 2:18 AM

All replies

  • User3866881 posted

    what error have you got?

    And what structs of the database you have?

    Maybe should tell us……

    And until now, without your detailed information you can try this instead of using join……

    select field1,field2,……,fieldN

    from table1,table2

    where (table1.XXX = table2.XXX And ……)

     

    Friday, March 11, 2011 10:30 PM
  • User1867929564 posted

    http://forums.asp.net/p/1661976/4338569.aspx/1?Re+INNER+JOIN+string+that+works+in+MDB+but+gives+me+an+error+in+MS+SQL+

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 14, 2011 2:18 AM