left join 报错

SELECT * FROM user_info ui LEFT JOIN ( user_his uh , user_change_his uch) on (uh.user_id = ui.user_id and uch.user_id = ui.user_id)

这个语句执行报错，我已经创建了对应的表，但是执行还是报错:

2025-05-27 02:22:00,726 WARN (mysql-nio-pool-151|28422) [ConnectProcessor.handleQueryException():471] Process one query failed because.
org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 1:
... user_info ui LEFT JOIN ( user_his uh,user_change_his ...
                             ^
Encountered: IDENTIFIER
Expected