Forum Stats

  • 3,740,448 Users
  • 2,248,256 Discussions
  • 7,861,252 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

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: 33 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.

    User_MNC5N

Answers

Sign In or Register to comment.