Re: Complex join problem with lookup table - need Help

From: Patrick Meyer <buckeye234_at_excite.com>
Date: Wed, 3 Apr 2002 13:39:53 +0000 (UTC)
Message-ID: <8ac38a4c9353dad879d575ae71f3614f.61632@mygate.mailgate.org>

Galen is correct. You just include the emergency_role table twice in the from clause. Give each one a unique alias:

Select eresp.employee_id, erole1.emergency_role_name, erole2.emergency_role_name
from emergency_responder eresp,

          emergency_role erole1,
          emergency_role erole2
where eresp. emergency_position_seq_number = erole1.emergency_role_name
and      eresp.alternate_position_seq_number =

erole2.emergency_role_name;

This should do exactly what you want. Give it a try and see.

HTH,
Patrick  

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Apr 03 2002 - 07:39:53 CST