How to add fields from other modules in Drupal 6 Views?
You can try out the below modules. They are meant for getting data directly from the database into views.

Table Wizard

Data Model

If both of them doesn't suit your requirement then you could use the Views Custom Field write php code directly into the view and collect the required fields using database queries. 

You could also do the direct query with in the views template files.