How to use Views 3 API to display custom tables?
After lots of research and work, this answer is for people who faced the same problem. The Data module does this for you. This module allows you to adopt a table (created in your Drupal Database and is not a part of any content type, basically a standalone table) and creates a view for that table. The view can be customized. The requirement here is that the table must have a primary key. You can also index this view by creating a content type and using the Views References Module. This will facilitate the indexing of the content in the table and make it show up in search results. Hope this helps.