Hi,
I have the following query:
SELECT E.ROWID, E.J_LOCATION_ID, E.J_EVENT_ID, E.J_EVENT_DATE, T.J_EVENTTYPES_NUMBER, E.J_EVENT_MESSAGE, E.J_EVENT_COMMENT, E.J_EVENTSTATUS_ID, S.J_EVENTSTATUS_NUMBER
FROM TSYS.DD_F_EVENTS E, TSYS.DD_L_EVENTTYPES T, TSYS.DD_L_EVENTSTATUS S
WHERE...