Hello
I was wondering if you can join several tables in Cognos. Below is my statement which does not work when i add a third table.
SELECT a.evt_code, b.obj_code, c.par_code,
b.obj_desc,
a.evt_desc,
a.evt_workaddress,
a.evt_status,
a.evt_class
FROM r5events a
FULL JOIN r5objects b, r5parts c
on a.evt_code = b.obj_code, c.par_code
Please can you help
Many Thanks
Chris