[AccessD] A2000: DELETE query with JOIN

David,

I tried it Access 2000 and Access complains with "The Microsoft Jet
database engine does not recognize DISTINCT T1.* as a valid field name
or expression."

Steve Erbach


On Fri, 18 Feb 2005 14:57:43 +0000, David Beckles
<becklesd at tiscali.co.uk> wrote:
> 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.