If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cross join three table

Started by cbyrne, 15 Sep 2009 03:50:15 AM

Previous topic - Next topic

cbyrne

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