Re: DBACCESS Impossibility?????

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