|
solution
SELECT mobile.local, mobile.zonal
FROM
contact,
(select mobilecoph.contact_id as contact_id, max(mobilephone.PHONENR_ID), max(mobilephone.LOCALNR) as local, max(mobilephone.ZONALNR) as zonal
from contactphonenr mobilecoph, phonenr mobilephone
where mobilecoph.phonenr_id = mobilephone.phonenr_id(+)
and mobilephone.phonetype_enumid(+) = 4
group by mobilecoph.contact_id) mobile
WHERE mobile.contact_id(+) = co.CONTACT_ID
and co.CONTACT_ID = 200057
|