Need to know who added & changed - ADDEDBYID & CHANGEBYID

Paul Wakeman

Hello,

Looking at finding out who added and changed CORRESPONDENCEPROCESS.

From this query:

select CC.*

from dbo.CORRESPONDENCECODE AS CC

order by CC.NAME

What table would I join to, to get the user name, using the CC.ADDEDBYID or CC.CHANGEBYID?

Thx,

PAW