prb88 (4/29/2013)
thanks but i am told not to use a view but to actually update the reasonforreferral column from table a with the description column from table B with an update join statement.
Bad choice. That means everytime you change the description in TableB you will have to go back and update TableA with the new description, unless it is okay for the old description to remain.