join: inner, right, left - orm d7

use Bitrix\Main\Entity\ReferenceField;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Query\Join;

class UsersTable extends DataManager{
    public static function getTableName()
    {
        return 'users';
    }
    
    public static function getMap()
    {
        return [
            new IntegerField('ID', ['primary' => true, 'autocomplete' => true]),
            new StringField('NAME'),
            new StringField('EMAIL'),
            new StringField('CITY'),
        ];
    }
}

class OrdersTable extends DataManager
{
    public static function getTableName()
    {
        return 'orders';
    }
    
    public static function getMap()
    {
        return [
            new IntegerField('ID', ['primary' => true, 'autocomplete' => true]),
            new IntegerField('USER_ID'),
            new StringField('PRODUCT'),
            new IntegerField('PRICE'),
            new StringField('STATUS'),
        ];
    }
}

SELECT USERS.NAME, ORDERS.PRODUCT, ORDERS.PRICE
FROM USERS
LEFT JOIN ORDERS ON USERS.ID = ORDERS.USER_ID

$result = UsersTable::getList([
    'select' => ['NAME', 'PRODUCT' => 'ORDER.PRODUCT', 'PRICE' => 'ORDER.PRICE'],
    'runtime' => [
        new ReferenceField(
            'ORDER',
            OrdersTable::class,
            Join::on('this.ID', 'ref.USER_ID'),
            ['join_type' => Join::TYPE_LEFT]  // LEFT JOIN (можно не указывать, это по умолчанию)
        )
    ]
]);

SELECT USERS.NAME, ORDERS.PRODUCT, ORDERS.PRICEFROM USERS
RIGHT JOIN ORDERS ON USERS.ID = ORDERS.USER_ID

$result = OrdersTable::getList([
    'select' => ['NAME' => 'USER.NAME', 'PRODUCT', 'PRICE'],
    'runtime' => [
        new ReferenceField(
            'USER',
            UsersTable::class,
            Join::on('this.USER_ID', 'ref.ID'),
            ['join_type' => Join::TYPE_LEFT]  // LEFT от Orders = RIGHT от Users
        )
    ] ]);

SELECT USERS.NAME, ORDERS.PRODUCT, ORDERS.PRICE
FROM USERS
INNER JOIN ORDERS ON USERS.ID = ORDERS.USER_ID

$result = UsersTable::getList([    
   'select' => ['NAME', 'PRODUCT' => 'ORDER.PRODUCT', 'PRICE' => 'ORDER.PRICE'],
    'runtime' => [
        new ReferenceField(
            'ORDER',
            OrdersTable::class,
            Join::on('this.ID', 'ref.USER_ID'),
            ['join_type' => Join::TYPE_INNER]  
        )
    ]
]);