我相信您必须像这样对源数据进行别名:
USING (select SOR.identity_column, CASE WHEN left(SOR.FPARTNO, 2) = 'BL' THEN 'Blue'WHEN left(SOR.FPARTNO, 2) = 'RD' THEN 'Red'ELSE 'White' END from Sorels AS SOR) **AS SOR** ON (SORe.fkey_id = SOR.identity_column)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)