1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Select stmt

Discussion in 'SQL PL/SQL' started by akika, Sep 12, 2017.

  1. akika

    akika Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    New Delhi
    Hi
    Please help...

    I've the attached table structure & data.

    From which I have a list of screen Ids from tbl_screen, and would like to get a list of users assigned, their privilege & access
    e.g
    Get the digits from the ID Student.mod.456.std in tbl_screen
    this digit is prefixed with @ and added in tbl_user field user_screen @456
    then get which rights is attached to this users (tbl_user & tbl_user_rights id)
    then get the action priviledge from tbl_user_access

    Any idea.. how to build the select statement pls?
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,517
    Likes Received:
    360
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Yes, we have ideas but it's not our assignment to do, it's yours. Post the code you have, and if you don't have any you should speak with your instructor and request help. We're here to help and we'll be happy to do that once we know you've at least attempted the assignment.

    It's good that you included the create table statements but without any sample data they are pretty much useless.
     
  3. akika

    akika Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    New Delhi
    I've uploaded the select stmt used in attached doc
     

    Attached Files: