rbase-l  

updating a table

Atrix Wolfe
Mon, 16 Dec 2002 15:15:49 -0800

hi, if i have the following:
 
NameTable
  Name Text(7)
  ID int
 
InfoTable
  Name
  ID
 
where NameTable is a bunch of names you can lookup by id or lookup id's by name and info table is a table which only has "Name" populated...is there a way to populate ID easily?
 
i tried this but of course it didnt work...shucks:
 
update InfoTable,NameTable set InfoTable.ID=NameTable.ID where InfoTable.Name=NameTable.Name
 
any help is greatly appreciated (:
  • updating a table Atrix Wolfe