How to use custom tables in any views?
You can use hook_views_query_alter and alter the views query by merging your custom query with the views SQL query itself.

Also there is an option in "advanced" section - theme suggestions
There you can write your custom query to fetch results into tabular format.