SELECT
GNMEETING.IDMEETING,
GNMEETING.NMMEETING,
GNMEETINGSUBJECT.NMSUBJECT,
ADALLUSERS.NMUSER,
TEXTOBSERVATION.TXDATA,
TEXTDECISION.TXDATA AS DATADECISION
FROM
GNMEETING
INNER JOIN
GNMEETINGSUBJECT ON GNMEETINGSUBJECT.CDMEETING = GNMEETING.CDMEETING
LEFT JOIN
ADALLUSERS ON ADALLUSERS.CDUSER = GNMEETINGSUBJECT.CDRESPONSIBLE
LEFT JOIN
SERICHTEXT ON SERICHTEXT.OID = GNMEETINGSUBJECT.OIDOBSERVATION
LEFT JOIN
SETEXT TEXTOBSERVATION ON TEXTOBSERVATION.OID = SERICHTEXT.OIDTEXTCONTENT
LEFT JOIN
SERICHTEXT DECISION ON DECISION.OID = GNMEETINGSUBJECT.OIDDECISION
LEFT JOIN
SETEXT TEXTDECISION ON TEXTDECISION.OID = DECISION.OIDTEXTCONTENT
WHERE
GNMEETING.IDMEETING = 'IDENTIFICADOR_DA_REUNIÃO' /* OBS 1 */ ORDER BY GNMEETINGSUBJECT.CDSUBJECT /* OBS 2 */
|