How to select by the nearest date from the departure records to the date of receipt and connect two database tables in 1s enterprise?

Question

Database

1. There are two selection tables, one contains data on when we received the nomenclature (equipment) and from where. The second table contains data on when the nomenclature left us and where. It is necessary to combine these two tables into one table, so that:
each receipt record corresponds to a record from another table about departure (by the nearest date of departure). There can be several records of departure from one organization.
Tell me, please, how, with what command (code) can you select data on departure by the nearest date of departure to the date of receipt?

Answer 1

Новый Запрос("");
Place the cursor between the quotes and right-click on the "Query Builder" menu item.
Laba there.
You get in quotes a construction like

"ВЫБРАТЬ
  |	ПартииТоваровНаСкладах.Номенклатура,
  |	Продажи.ДокументПродажи
  |ИЗ
  |	РегистрНакопления.ПартииТоваровНаСкладах КАК ПартииТоваровНаСкладах
  |		ВНУТРЕННЕЕ СОЕДИНЕНИЕ РегистрНакопления.Продажи КАК Продажи
  |		ПО ПартииТоваровНаСкладах.Номенклатура = Продажи.Номенклатура"