Forum Stats

  • 3,839,153 Users
  • 2,262,456 Discussions
  • 7,900,869 Comments

Discussions

Cross table

User_MNC5N
User_MNC5N Member Posts: 1 Green Ribbon
edited Feb 9, 2021 12:45PM in Social Groups

Hello, I am a new member of this group

I'm working on oracle ADF12c

I ask you to answer me the following question

I have a "salary" master table

And I have three sub-tables (employees,Deduction,allocations)

I want to make an SQL expression like a table

"Total Salary"

thanks


Best Answer

  • Dave_VZ
    Dave_VZ Member Posts: 45 Red Ribbon
    Answer ✓

    My compliments on the graphic, and my puzzlement on the logic. Regretfully my experience is with normalized, relational models, much like the HR model that Oracle traditionally uses as a sample. I realize I am misinterpreting your intent.

    As far as learning how to code an inner join on three or more tables, perhaps do a web search using the phase I just provided? I hope this helps.

    User_MNC5N

Answers