SQL that Fetches

I need some help on written an SQL that would pull from blob "text" field. I have a sql that uses distinct section and union section clause. I removed the text field from the SQL but now I still need to pull the text field . I need to fetch data using a "read" statement .

example:
IFS="|" read -p as_lead_caseid nh_id nh_note_id not_seqno note_type not_documn

I am not sure on how to do fetch that would pull the nh_note_text using nh_id and nh_note_id.