Hi, Does anyone know how to select from one table (using a conditional statement) and then insert the resulting data into a empty column within said table. For example, if column B has as its possible entries (potatoe, carrot & squash) - add vegetable to column C. Thanks,
Frank
