Re: The (+) outer join operator.
From: Kurt Staud <llgi_at_avlrax01.br.vlr.gv.at>
Date: Tue, 29 Nov 94 12:17:35 PST
Message-ID: <3bf2lj$hdc_at_c2.eunet.co.at>
Date: Tue, 29 Nov 94 12:17:35 PST
Message-ID: <3bf2lj$hdc_at_c2.eunet.co.at>
I´m trying my best.
The + Operator makes it possible, that you see the tuples in the result set too, which don´t have any child in the child-table. Look at page 4-373 SQL Language Reference Manual.
You see the department 40 Operations which has no monthly salary, because there are no employees in this department, and therefore the monthly salary is null, but the depatment is listed in the result set. If you don´t set the + Operator in the depending table (child), the department will not be displayed (4-372).
Kurt
llgi_at_avlrax01.br.vlr.gv.at
Bregenz, Austria
Received on Tue Nov 29 1994 - 21:17:35 CET