Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Entity primary key with null value  RSS feed

Jack Lau
Ranch Hand
Posts: 168
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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?

[ December 17, 2007: Message edited by: Jack Lau ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!