Is there a way to add a relationship to the node history table in views. If not, is there a module which can do it?
As it turns out the history table is already available under views as part of the content section (field 'Has new Content').
Download Views Field View module and install it.
Next create a new view that shows content revision instead of content. See image below.
Pull in the fields you want to see. See Image below.
Add a views contextual filter. See Image below.
Add the Content: Nid field as the contextual filter. Image below.
Configure the field as below.
Next edit your original view that pulls over the current content. Add a field and select the Content: Nid. Make sure to uncheck the Create Label checkbox. We just want the number. Then check the exclude button.
Now we add the views_field_view to the view via the field section of the view. You should select Global: View.
Now we configure it like the image below.
Save your view and now you should be able to go and see each node along with the historical data.
As it turns out the history table is already available under views as part of the content section (field 'Has new Content'). It is just a bit limited in use as it brings in the current user only as a user relationship.
Luckily there is a patch to fix that.