How to make the right request in 1s?

Question

Automation

There are 3 tables:
1) Schedule of tours
2) Appointment of prices for tours
3) Payment for tours
The first table stores the name of the tour, the second table contains the name of the tour (as in the first table, but you need to make sure that the first table also participates in the query) and its price , in the third, the name of the tour and who paid, how is it better to display the result from 3 tables into one -> Tour name, its price and who paid, how is it better to make a request?

Answer 1

You here
www.spec8.ru/kurs-po-skd-besplatno
helpme1c.ru/zaprosy-v-yazyke-1s-8-v-primerax
Read it.
Having no idea what objects it is difficult to represent the request.
But I can definitely say that from this opera
helpme1c.ru/soedineniya-v-zaprosax-v-1s-8-v-primerax