David Beckles
becklesd at tiscali.co.uk
Fri Feb 18 08:57:43 CST 2005
Dear Steve, Sorry, but I am not talking about T-SQL, something that I have never used (I'm an Oracle person, myself <g>). Why not try it? It certainly works for me in A2002. See http://www.mvps.org/access/queries/qry0022.htm or http://eis.bris.ac.uk/~ccmjs/access2000_distinct.htm for an explanation. David >Message: 12 >Date: Fri, 18 Feb 2005 05:55:51 -0600 >From: Steve Erbach <erbachs at gmail.com> >Subject: Re: [AccessD] A2000: DELETE query with JOIN >To: Access Developers discussion and problem solving > <accessd at databaseadvisors.com> >Message-ID: <39cb22f305021803557d3f7845 at mail.gmail.com> >Content-Type: text/plain; charset=US-ASCII > >David, > >I think you're talking about T-SQL. I'm trying to do this in A2000. > >Steve Erbach > >