一個很奇怪的問題，希望各位高手進來看看！

[arangly]

Select Firm From Sc_GuestOrder
Firm
1 玫瑰

Select Sc_ZydPo.Po From Sc_ZydPo
Po
1 K0305-1024R1

Select Firm From Sc_GuestOrder Where Sc_GuestOrder.Po IN (Select Sc_ZydPo.Po As Po From Sc_ZydPo)
Firm

為什麼最後一句會找不到記錄?是我的語法寫的有錯嗎，請高手指點!多謝!

[pengdali]

try:

Select Firm From Sc_GuestOrder Where rtrim(Sc_GuestOrder.Po) IN (Select rtrim(Sc_ZydPo.Po) From Sc_ZydPo)

[yoki]

Select Firm
From Sc_GuestOrder
Where replace(Sc_GuestOrder.Po,' ','') IN (Select replace(Sc_ZydPo.Po,' ','') From Sc_ZydPo)

[yonghengdizhen]

进行去除空格的操作后,你还必须检查对应字段是否有相同值