How to create a dynamic change history view for all node revision log messages within a single book

Anybody have suggestions for how to create a relationship between the node revisions table and book table?

Thanks for the input. The node_revision->node relationship is available. Here is the query that I need to generate:

SELECT node_revisions.vid AS vid,
   node_revisions.timestamp AS node_revisions_timestamp,
   node_revisions.title AS node_revisions_title,
   node_revisions.nid AS node_revisions_nid,
   book.bid AS node_revisions_bid,
   users_node_revisions.name AS users_node_revisions_name,
   node_revisions.log AS node_revisions_log
 FROM DP_node_revisions node_revisions 
 LEFT JOIN DP_users users_node_revisions ON node_revisions.uid = users_node_revisions.uid
 LEFT JOIN DP_node node ON node_revisions.nid = node.nid
 LEFT JOIN DP_book book ON node.nid = book.nid
 WHERE (UPPER(node_revisions.log) != UPPER('')) AND (node.type in ('book')) AND (book.bid = 515) AND (node_revisions.vid <= node.vid)
   ORDER BY node_revisions_timestamp DESC

Basically, I need the following:
1. Ability to join the node_revisions table with the node table and the book table.
2. Ability to pass in the root book node id as a parameter
3. Additional revision version filter for filtering out revision log messages for revisions that haven't been published yet.

From the views source code documentation, "The base relationship handler can only handle a single join. Some relationships are more complex and might require chains of joins; for those, you must utilize a custom relationship handler." It seems that I would need to create a custom relationship handler to join the node_revisions table with both the node table and book table.

Does anyone know if that is the correct direction? Any other thoughts or suggestion for how to approach the custom relationship handler? Many thanks!

I don't see a method in 6.x 2.3 to create a node_revision -> node relationship. It seems to be one of what the documentation calls an implicit relationship.

merlinofchaos (or others), appreciate the feedback, but wondering if you have any other thoughts. Again, the book-related information is not available when the 'node revision' base is chosen in Views. When choosing 'node' as the base, they work. Thanks again!