DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: simple view

  1. 11-11-2005, 04:35 AM #1
    jbreusch
    jbreusch is offline Junior Member
    Join Date
    May 2005
    Location
    Frankfurt
    Posts
    2

    simple view

    Hi guys,
    please don't start laugh but I'm not an SQL developer. I have get a request to create a view which should list user which have completed a renewal of certification. There are two tables involved and user could be in one or in both.
    The variables are equal in both table.
    user_id
    certification_id
    status_id
    I get it work with one table but not with both.
    I would thank you in advance for your help.
    JB
    Reply With Quote Reply With Quote
  2. 11-11-2005, 07:17 AM #2
    Scorby
    Scorby is offline Member
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    What is the structure of the two tables involved in the query ? You only seem to have given one here.
    Reply With Quote Reply With Quote
  3. 11-11-2005, 07:43 AM #3
    jbreusch
    jbreusch is offline Junior Member
    Join Date
    May 2005
    Location
    Frankfurt
    Posts
    2
    I have found what I need. I have created 2 views and created an other one who unioned the result of both.
    cheers
    Reply With Quote Reply With Quote
  4. 11-11-2005, 12:33 PM #4
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Why 2 views?
    One view with 2 tables is enough.

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width