Joining Several Tables is this possible

[cbyrne]

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