https://www.webmaster-forums.net/crss/node/1013838 en https://www.webmaster-forums.net/web-database-development/sql-help-0#comment-1080083 <p>Andy,</p> <p>Try this:</p> <p>SELECT UserTable.UserID,FirstName,LastName,AccountTable.UserID<br /> FROM UserTable,AccountTable<br /> WHERE UserTable.UserID &lt;&gt; AccountTable.UserID</p> <p>Just replace table &amp; field names with the real ones.</p> Wed, 28 Mar 2001 17:29:17 +0000 Peter J. Boettcher comment 1080083 at https://www.webmaster-forums.net