G
Guest
Table 1:
System Function
____________________
A Func1
A Func2
A Func3
B Func1
B Func3
C Func1
C Func2
D Func1
D Func2
D Func3
E Func2
E Func3
....
Table 2
User System
__________________
User1 A
User2 D
....
Inputparameter : string of functions ( "Func1-Funct2-..." ) separted by a
specific char.
Question :
How to select from table1 all systems not assigned to a user and
having all of the functions mentionned in the inputprm implemented.
For inputprm = "Func1-Funct2-" the answer would be :
System
______
C
(1 record)
Thanks in advance.
System Function
____________________
A Func1
A Func2
A Func3
B Func1
B Func3
C Func1
C Func2
D Func1
D Func2
D Func3
E Func2
E Func3
....
Table 2
User System
__________________
User1 A
User2 D
....
Inputparameter : string of functions ( "Func1-Funct2-..." ) separted by a
specific char.
Question :
How to select from table1 all systems not assigned to a user and
having all of the functions mentionned in the inputprm implemented.
For inputprm = "Func1-Funct2-" the answer would be :
System
______
C
(1 record)
Thanks in advance.