Thread: sql question

Hi all

Can anyone tell me if there is a way of doing the query bellow, do i have to
do 4 queries or is there a way of just doing one?

thanx in advance.


the following table tells me is who (per_key) is a systems manager,
administrator, second call out and hardware call out for a system.

         Table "per_sys"
 Attribute  |   Type   | Modifier
------------+----------+----------
 system_key | smallint |
 per_key    | smallint |
 man        | boolean  |
 admin      | boolean  |
 second     | boolean  |
 hard       | boolean  |


select
system.name as name,
personal.name ||' '|| personal.surname as name_man,
personal.name ||' '|| personal.surname as name_admin,
personal.name ||' '|| personal.surname as name_second,
personal.name ||' '|| personal.surname as name_hard
where
system.name IS NOT NULL and
per_sys.per_key != 0 and
((personal.key_personal = per_sys.per_key and per_sys.man = 't') or
(personal.key_personal = per_sys.per_key and per_sys.admin = 't') or
(personal.key_personal = per_sys.per_key and per_sys.second = 't') or
(personal.key_personal = per_sys.per_key and per_sys.hard = 't'))
order by system.name;