It sounds like they would be two teams who work together out of necessity and thus have a relatively cordial relationship with a side of tension because of course the Order will work with heretics if they have to (as they consider everyone who deals with daemons heretics) but they also will definitely have contingency plans for "dealing" with each other if it ever came to that.