I have written a SQL statement for currency table and customer_bank table, but the selected fields no need to include the primary key "curr_code" in the statement. When I run the application, it shows the following message. So I add the primary key fields to the select statement, however, it also show the same message. Finally, I replace the outter join "curr.curr_code (+)= cb.bank_curr_code" into inner join "curr.curr_code = cb.bank_curr_code", it works but the result is not I expected.
Is the primary key of the entity must selected or fill in non-null value?
Thanks, Jack [ December 17, 2007: Message edited by: Jack Lau ]