Creating views - a newbie guide...

[robmason10]

As it seems that no-one has the time to create 'views' to be used as report data sources rather than looking directly at the tables would anyone be so king as to give a high-level guide as to how to create views?

Cheers in advance

 

[bigfoot]

Views are just a form of query. Open Enterprise Manager, navigate down to your database. Open the Views tree leaf, and right click on the leaf where it says Views.

This will open a query window.
Up at the top there is an icon to add tables. Click on it to add as many tables as you need. Then connect the tables as you would to create a query.

When you exit, it will ask you to save. Give it a name, and now you can use that name like you would the name of a table in a select statement, but you will be looking at your view, and not your table.

Hope this helps.