« What files do I replace from statement below and how?
Write a program that asks the user to enter a number within the range of 1 through 10 Using a switch statement? »

SQL statement?

November 3, 2009 - 8:54 am

I have column name "PROCESS" and "USER" with same table.PROCESS has process1,process2,process3……process100 and every process has a different user but not all users has the access in every process there are only some..
Question: how can i create a statement that i can only view all users that can access all the processes???
any suggestion or comments is highly appreciated.
a big thanks..

mel
e.g.
table name: Table
Column: PROCESS, USER

PROCESS USER
process1 A
e.g.
table name: Table
Column: PROCESS, USER

PROCESS USER
process1 A
B
C
process2 D
E
C
process3 F
G
H
C
process4 I
C
J
K
:
:
:
process100 L
M
Z
C
users are A,B,C,D,E,F,J……….Z
process are process1, process2…..Process100
which user has the access on all the processes???

http://answers.yahoo.com/question/index?qid=20070110195245AA0tYW6

Posted sql statement |

2 Responses to “SQL statement?”

  1. newbie_me Says:
    November 3rd, 2009 at 2:02 pm

    can you please elaborate your question

    in my first understanding:

    tablename: table
    columns: PROCESS, USER

    PROCESS USER
    process1 A
    process2 B
    process3 C

    is this what u mean?

    this might be the answer

    SELECT USER FROM table WHERE PROCESS = ‘PROCESS’

    E.G. based on the table
    SELECT USER FROM table WHERE PROCESS = ‘process1′
    References :

  2. dhvrm Says:
    November 3rd, 2009 at 2:33 pm

    http://answers.yahoo.com/question/index?qid=20070110195245AA0tYW6
    References :

Leave a Reply