[AccessD] A2000: DELETE query with JOIN

Hi Steve

First, DISTINCT is not the same as DISTINCTROW.
Second, using DISTINCT you can't just select all (*), you have to
specify the fields to select.

/gustav

>>> erbachs at gmail.com 18-02-2005 22:21:14 >>>
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."