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?
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?