Did you try what I gave you? Oracle does not nor ever has supported [to my knowledge] the RIGHT JOIN or LEFT JOIN syntax in a SQL statement. You have to use the (+) to do that.

SELECT * FROM dataACP, dataFIRM WHERE dataACP.MNR = dataFIRM.FIRMNR(+) and dataFIRM.kategor='1'

>Sorry, i meant 8.1.6
>
>i use the syntax of the ansi standard:
>
>SELECT * FROM dataACP RIGHT JOIN dataFIRM ON dataACP.MNR = dataFIRM.FIRMNR WHERE dataFIRM.kategor='1')
>
>The syntax seems right, perhaps 8.1.6 needs the "old" syntax ? (+)
>achim