Help with RR SQL version 9
Posted: Fri Nov 22, 2002 6:07 am
Please could someone help me i need to find all the duplicate accident numbers in the report. The SQL is shown below.__The database is connected by Oracle ODBC____select__ CASSACCI."ACCIDENTNUMBER", CASSACCI."ACCIDENTDATE", CASSACIN."ACCIDENTNUMBER", CASSACIN."FORENAMES", CASSACIN."CONTACTTELNUMBER", CASSACIN."SURNAME", CASSACIN."OHSEENBY_ACCIDENT"__ from __CASS.CASSACCIDENTS CASSACCI, CASS.CASSACCIDENTINJURY_VIEW CASSACIN __where__CASSACIN."PIN" <> ^1^__order by__ CASSACIN."OHSEENBY_ACCIDENT"____Thanks in advance i^m waiting for my SQL training!!____Martin