On 20 Dec 1995, Mark Truty wrote:
} Is what I am trying to do impossible in DBACCESS??
}
} I have a file with two columns, (name, cus_no)
}
} I have a table with 50 columns, three of which are ( name,
} cus_no,number)
} I want to update the rows in the table with a number if the name and
} cus_no are the same from the file.
}
} I tried
}
} create temp table mark
} (mname integer,
} mcus_no integer);
} load from file insert into mark;
}
} update customer
} set number = 100
} where
} name = mark.mname and
} cus_no = mark.mcus_no
}
} This does not work. It says no table named mark in query. Any
} suggestions?????
} Thanks
} Mark
}
Mark,
You're missing the mark table name in the where. Try something
like this -
update customer
set number = 100
where name in
(select mname from mark )
and cus_no in
(select mcus_no from mark ) ;
Hope this gets the wheels turning,
Nick