How to use data from several existing database tables

Sometimes you may want to connect to existing database tables but display data from several existing database table in a single query. With normal Aware IM objects you can do it using shortcuts. With existing database tables you can also define a “normal” Aware IM object that would have references to different objects stored in the existing database tables and then define shortcuts to different attributes in these objects.

A better approach, however, is to define a view in the existing database that would select data from different tables, and then create a special Aware IM object that would point to this view.