How to create the view of multiple tables

table

1> db => file: relatedObjectMap. Map the source and destination tables.
2> Like above way, you can add also another record connecting to more than one files.
3> After completed, go to view and create view. Then when adding columns once you select the source table it will auto open the lock for the other table fields to be displayed and you can add to the column list
4> Prepare the view in that way and then fetch/view the data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s