https://www.webmaster-forums.net/crss/node/1020576 en https://www.webmaster-forums.net/web-database-development/sql-first#comment-1126124 <p>I'm not that familiar with MS Access's fake queries... But I'm assuming that 'First' returns the top record?</p> <p>MS SQL:<br /> SELECT TOP 1 * FROM ...</p> <p>mySQL<br /> SELECT * FROM ... LIMIT 1</p> Tue, 25 Feb 2003 21:18:19 +0000 Mark Hensler comment 1126124 at https://www.webmaster-forums.net