On Sat, 27 Oct 2001, stephen wrote:
> i was wondering if it's possible to make a delete query to delete only
> one of the two fields in a table. I have tried only putting that
> field as the "from" but it still deletes the other field also?
AFAIK delete works on entire rows. What is it you want it to do
preciselfy? If you want to set the other value to null, an update
is probably really what you want.