select *,site_id from
(select distinct goods_sn,site_ids,split(site_ids, ',') array from prm
where goods_sn='abcdefg')
cross join unnest(array) t(site_id)
可以執行
select a.*,b.site_nm from
(select *,site_id from
(select distinct goods_sn,site_ids,split(site_ids, ',') array from prm
where goods_sn='abcdefg')
cross join unnest(array) t(site_id)) a left join
(select distinct site_id,site_nm from pub) b on a.site_id=b.site_id
就報錯了，提示Column 'a.site_id' is ambiguous
怎么解決呢
uj5u.com熱心網友回復：
參照方式：https://bbs.csdn.net/topics/240002706轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/76424.html
標籤：疑難問題
上一篇：JAVA小白