There are 3 tables:

1 table:

ID | FIO | zakaz_STU С данными: 1 | ИВАНОВ ИВАН ИВАНОВИЧ | 1 2 | Петров ИВАН ИВАНОВИЧ | 2

2 table:

 ID | ID_CLIEN | ID_DATE_POS 1 | 1 | 1 2 | 2 | 1 3 | 1 | 3 4 | 1 | 4 5 | 1 | 5

3 table:

 ID | DATE | OPO_RAS С данными: 1 | 12.01.2018 | 1 2 | 12.01.2018 | 2 3 | 10.01.2018 | 3 4 | 15.01.2018 | 2 5 | 15.01.2018 | 3

Necessary: ​​Display the table in this way:

 ФИО | 12.01.2018 | 10.01.2018 | 15.01.2018 Иванов | 2 | 2 | 4 Петров | 2 | 0 | 0

The picture is described in more or less detail. I would be very grateful for the help. I do not understand how to do it myself (

one

  • that does not work? - Roman C
  • Cannot generate SQL query. Can not display in the desired form. - user298581
  • this is called chess - Yevgeny Gusev
  • I am not interested in what you should get or not. I am interested in the problem with which you encounter and your attempts to overcome it. Start with how you are going to do it. - Roman C
  • you understand i'm getting lost i don't even understand how to make a sql query - user298581

0