Access’ DISTINCTROW keyword explained – it means WHERE EXISTShttp://msmvps.com/blogs/robfarley/archive/2009/06/11/access-distinctrow-keyword-explained-it-means-where-exists.aspxSteve Koop spoke recently at the Adelaide SQL Server User Group , talking about things which don’t convert particularly nicely when upsizing from Microsoft Access to SQL Server 2008. I think this is a really important thing for SQL people to know, asenCommunityServer 2008.5 SP2 (Build: 40407.4157)