posted 19 years ago
I want to invoke rows from a table in such a way that ,
suppose employeeAccess is my table i want to fetch all the records from employeeAccess table which
satisfy the following criteria as
if accessid = 1 then accessval = 'all'
<b>And</b>
if accessid = 2 then accessval = 'read'
I don't want to make the condition either or.
Suppose my table has some values like -
Empidaccessidaccessval
11all
12write
13read
14all
21all
22read
23write
24read
31read
32read
33write
34all
In the above case i only want to fetch the empid 2 . Neither 1 nor 3, as only
empid = 2 satisfy both condition that is for
empid = 2 when accessid = 1, accessval is 'all'
and when accessid = 2, accessval is 'read'
empid = 1 record is not expected, as in this case
when accessid = 1, accessval is 'all'
but when accessid = 2, accessval is something other than 'read'
empid = 3 record is also not expected, as in this case
when accessid = 2, accessval is 'read'
but when accessid = 1, accessval is something other than 'all'
Please, help me outof this.
Note: I can't change the table format.