Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT an.note_id, an.NOTE_TITLE, an.NOTE_BODY, an.mod_date, usr.full_name, usr.user_email,
2 
	   an.mod_date ||' by '|| usr.full_name AS lastmod
3 
  FROM ADDITIONAL_NOTES an,
4 
	   USERS usr
5 
 WHERE an.pv_id = :PV_ID
6 
   AND an.mod_user = usr.user_id
7 
 ORDER BY an.note_id