Inner Join works in MDB but not in ACCDB

Joined
Mar 10, 2011
Messages
1
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top