SELECT
 i.equip_pk,
 i.request_pk,
 MY_ALIAS.EQUIP_ALIAS_ID
 FROM
 tableOne i
 JOIN table2 MY_ALIAS ON (i.EQUIP_PK = MY_ALIAS.EQUIP_PK)
 WHERE i.request_pk=:requestPk

SELECT
 i.equip_pk,
 i.request_pk,
 NVL(MY_ALIAS.EQUIP_ALIAS_ID, 'Nothing here')
 FROM tableOne i
 LEFT OUTER JOIN table2 MY_ALIAS ON (i.EQUIP_PK = MY_ALIAS.EQUIP_PK)
 WHERE i.request_pk=:requestPk

SELECT
 NVL(i.equip_pk, 'Nothing'),
 NVL(i.request_pk, 'Nothing)',
 MY_ALIAS.EQUIP_ALIAS_ID
 FROM
 tableOne i
 FULL JOIN table2 MY_ALIAS ON (i.EQUIP_PK = MY_ALIAS.EQUIP_PK)
 WHERE i.request_pk=:requestPk