sdfds

Sql code posted
created at 14 Oct 12:45

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
SELECT DISTINCT(lower(per.name)) AS name
FROM personnel_functional_group pfg,
  personnel per,
  functional_group fg
WHERE per.ID_NUMBER=pfg.PERSONNEL_ID
AND fg.id_number   = pfg.func_group_id
AND fg.name       IN
  ( SELECT DISTINCT(fg.name)
  FROM personnel_functional_group pfg,
    personnel per,
    functional_group fg
  WHERE per.ID_NUMBER =pfg.PERSONNEL_ID
  AND fg.id_number    = pfg.func_group_id
  AND fg.name IN (---ENUMERATION----)
  AND upper(per.NAME) = upper('zzmartis'));
502 Bytes in 2 ms with coderay