oracle查询时,select * from A where a.id in (select id from B);中a.id中字段比B.ID字段多个空格

要想匹配出这个结果,语句该怎么写
2024-11-23 06:39:17
推荐回答(1个)
回答1:

select * from A where trim(a.id) in (select id from B);