退房 using() 而不是 on -但是你必须使用所有的字段：

SELECT * FROM `xxx.yyy.111` AS ACT
    INNER JOIN `xxx.yyy.222` AS BOUND
    USING(ID, FieldID, FieldCropYear,UpdateUTC)

如果由于某些字段实际上不同而没有意义，请重命名子查询中的某些字段：

SELECT * FROM `xxx.yyy.111` AS ACT
    INNER JOIN 
     (select * EXCEPT(ID, UpdateUTC), ID AS actID, UpdateUTC as actUpdateUTC FROM `xxx.yyy.222`) AS BOUND
    USING(FieldID, FieldCropYear)

没有测试代码，但我希望方法是明确的

bigquery使用 replace :

SELECT bound.*,
       act.* REPLACE (id as id_act,
                      filedid as fieldid_act,
                      UpdateUTC as UpdateUTC_act,
                      FieldCropYear as FieldCropYear_act
                     )
FROM `xxx.yyy.222` BOUND JOIN
     `xxx.yyy.111` AS ACT
     ON BOUND.FieldID_b = ACT.FieldID AND
        BOUND.FieldCropYear_b = ACT.FieldCropYear;

注意：当我想从具有重叠名称的表中选择列时，我通常会选择它们作为记录：

SELECT BOUND, ACT
FROM . . .

不过，我不确定这是否适合你。