Forum Stats

  • 3,783,310 Users
  • 2,254,756 Discussions


Cross table

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"


Best Answer

  • Dave_VZ
    Dave_VZ Member Posts: 41 Red Ribbon
    Accepted 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.