Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Unanswered: views from 5 tables

    How can i create a view from 5 tables? I need the information for report writing.

  2. #2
    Join Date
    Jul 2003
    Posts
    38
    You can create your view from any number of tables. Put the joins between the tables correctly while selecting the required data.

    regards,
    avr.

  3. #3
    Join Date
    Oct 2003
    Posts
    87
    create view view1 as
    select a.col1, b.col2, c.col3 ...
    from tab1 a,
    tab2 b,
    tab3 c
    ...
    where a.col1 = b.col2
    and b.col2 = c.col3
    ...
    Oracle - DB2 - MS Access -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •