Hi



I need help with this query. I have to get the Individual Name from the
Individual table instead for am.sender No. and amr.recipient#



See those commented stuffs





select am.sender,

-- ind.first_name,

amr.recipient#,

-- ind.first_name,

-- am.alert_message_type,

am.subject,

am.body

-- ,amr.delete_flag

from

ALERT_MESSAGE am,

ALERT_MESSAGE_RECIPIENT amr

-- ,INDIVIDUAL ind

where am.alert_message#=amr.alert_message#

and am.reference#=102

and am.alert_message_type=2





Appreciate your help



-Baba






Oracle LazyDBA home page