--**************************************
--     
-- Name: How to create views and use the
--     m - *VOTE PLEASE*
-- Description:the purpose of this is to
--      show users how to create views and use 
--     them. this will give them ideas on how t
--     o setup views for certain types of data 
--     retrival... etc. Great for Newbie's
-- By: hamsters at xssi.net
--
--This code is copyrighted and has-- limited warranties.Please see http://
--     www.Planet-Source-Code.com/vb/scripts/Sh
--     owCode.asp?txtCodeId=472&lngWId;=5--for details.--**************************************
--     

'Creating Views
' ------------------------
'1) Simple View:
	CREATE VIEW TEST AS
	SELECT * FROM <table>;
' A) How TO USE this view:
	SELECT * FROM TEST;
'2) More Advanced Views:
	CREATE VIEW TEST_1 AS
	SELECT * FROM <table> 
	WHERE <field> = <value>;
' A) How TO USE this view:
	SELECT * FROM TEST_1;
'-------------
'
	CREATE VIEW COMP (<field1>, <field2>) AS
	SELECT * FROM <table>
	WHERE <field> = <value>;
'
' A) How TO USE this view:
	SELECT * FROM COMP;
'------------------
'
	CREATE VIEW ENVE (NAME, ADDRESS) AS
	SELECT FIRST_N + " " + LAST_N, ADDRESS + " " + CITY + ", " + STATE
	FROM CUSTOMERS;
'
' A) How TO USE this view:
	SELECT * FROM ENVE
'
'*******************************
'3) Updating Views IS pretty much the same thing AS updating a table. A view in SQL could be compared TO a "query"
' IN access. 
' IF you have ANY questions about ANSI-SQL, T-SQL, etc. AND would LIKE SOME free advice, please email us
' at: xhamsters@yahoo.com OR visit us at: http://www.xssi.net
'*******************************