I have a database with multiple tables. One table titled netbilling that contains (among others) the following fields:
ItemNum
ItemDesc
SubsChgs
I have another table titled billcode, I want to update the billcode table with data from the netbilling table. I want all of the fields above but I want to limit the update to distinct ItemNum. ItemDesc and Subschgs will also be distinct as every instance of ItemNum has the same ItemDesc and SubsChgs.
Any help is appreciated.
Ron--
ItemNum
ItemDesc
SubsChgs
I have another table titled billcode, I want to update the billcode table with data from the netbilling table. I want all of the fields above but I want to limit the update to distinct ItemNum. ItemDesc and Subschgs will also be distinct as every instance of ItemNum has the same ItemDesc and SubsChgs.
Any help is appreciated.
Ron--