Hello i am trying to join two tables in 1 query which has other attributes within it but i keep getting an error: QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-90'. ORA-03113: end-of-file on communication channel UDA-SQL-0023 The connection to the "Oracle" database has been terminated due to an unrecoverable error.
Does the below code look okay or am i missing something.
SELECT a.evt_code
, a.evt_desc
, a.evt_class
, a.evt_org
, b.ect_total
, b.ect_labor
, b.ect_event
, obj_code
, obj_org
, obj_variable5
, obj_variable6
, obj_production
, obj_status
, obj_category
, obj_desc
, obj_serialno
, obj_class
, obj_safety
FROM r5events a
, r5objects
FULL JOIN r5eventcosts b
on a.evt_code = b.ect_event
Many Thanks
Chris