hi sophi, you can create view with multitable, the view is created by select statment and you can include multitable in select statment by inner join or you can join the tables by where clauses. [ July 05, 2003: Message edited by: Maher Elsayd ]
Hi, you can indeed create a view with more than one table. About every SQL SELECT statement you can imagine can become a view. However not all views can be inserted on. If i remember correctly you can only insert on views based on one table and only i you use all the mandatory column and you also have to create the view WITH CHECK OPTION. Hope i remembered it correctly. For information just look in the online documentation on TechNet.
