Post reply

Using fields from a view in SELECT statement

  • October 7, 2005 at 4:23 am

    #595803

    Do as google search on SQL Views.  They are easy to create...

    create view as

    select a,b from table

  • October 7, 2005 at 8:09 am

    #595872

    Just use the view (after creating it as shown in the post above) as if it were a table like this:

    select * from myview

     

    You can use joins using regular tables and views to get the info you want.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply