BUG: join raises AttributeError: 'list' object has no attribute '_query_compiler'

[anmyachev]

Modin version checks

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest released version of Modin.

• I have confirmed this bug exists on the main branch of Modin. (In order to do this you can follow this guide.)

Reproducible Example

import modin.pandas as pd
import numpy as np

df1 = pd.DataFrame(np.ones([2,4]), columns = ['a','b','c','d'])
df2 = pd.DataFrame(np.ones([2,4]), columns = ['a','b','c','d'])
df3 = pd.DataFrame(np.ones([2,4]), columns = ['a','b','c','d'])

df1.join([df2, df3], how="inner", on="a")

Issue Description

Non-obvious error message.

Expected Behavior

In that case we should raise ValueError: Joining multiple DataFrames only supported for joining on index exception as pandas does.

Error Logs

File "test_join.py", line 8, in <module>
    df1.join([df2, df3], how="inner", on="a")
  File "C:\projects\modin\modin\logging\logger_decorator.py", line 128, in run_and_log
    return obj(*args, **kwargs)
  File "C:\projects\modin\modin\_compat\pandas_api\latest\dataframe.py", line 172, in join
    return self._join(
  File "C:\projects\modin\modin\logging\logger_decorator.py", line 128, in run_and_log
    return obj(*args, **kwargs)
  File "C:\projects\modin\modin\pandas\dataframe.py", line 1321, in _join
    other._query_compiler,
AttributeError: 'list' object has no attribute '_query_compiler'

Installed Versions

Replace this line with the output of pd.show_versions()