Create a view

Frizzell
Frizzell used Ask the Experts™
on
Need a view for the following:
SELECT CUSTOMERS.C_FIRST, C_MI, C_LAST, ORDERS.O_DATE, O_METHPMT
FROM CUSTOMERS INNER JOIN ORDERS ON CUSTOMERS.C_ID = ORDERS.O_ID;
call it test view
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Engineer
Commented:
Do you mean create view?

CREATE VIEW testview
AS
BEGIN
 SELECT CUSTOMERS.C_FIRST, C_MI, C_LAST, ORDERS.O_DATE, O_METHPMT
FROM CUSTOMERS INNER JOIN ORDERS ON CUSTOMERS.C_ID = ORDERS.O_ID;

END

To select,
SELECT * FROM testview

--Raj

Author

Commented:
Good Job Raj and thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial