Connecting Density Functional Theory and Green's Function Theory