I think a view should work. Have you tried? If it doesn't show in the list of tables in the user interface then you should be able to change the table name to the view name in the code after application and it would work.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.