Creating view covering multiple tables

[mrtblt]

How i can create a view which includes fields from multiple tables?

[chazzy]

views are just defined as select statements. if you can write the select statement, you can just turn it into a view.