Hello everyone, there is such a request

select B."IDGROUP", B."IDLESSON" from "GROUPSTUDING" B order by B."IDGROUP"

He prints the following

enter image description here

It is necessary that instead of numbers displays the name of the group and the lesson. For example:

 (IDGROUP) (IDLESSON) МС-42 Высшая математика

Here is the table with groups enter image description here

So with the lessons

enter image description here

  • 2
    Use inner join . - Sergey Gornostaev
  • one
    select G.NAMEGROUP, L.NAMELESSON from "GROUPSTUDING" B, "GROUPS" G, "LESSONS" L where L.ID=B.IDLESSON AND G.ID=B.IDGROUP ? - Chubatiy
  • @Chubatiy are you a wizard?) - freedom466
  • one
    @Chubatiy implicit join? Hello aliens from 1989! - Sergey Gornostaev
  • @SergeyGornostaev thanks, I now know that there is such a thing as join :) - freedom466

0