带in的查询:
select ltrim(rtrim(isnull(icddesc,'')))+'<br>'
from ref_ICD
where ICDCode in (select ICDCode from billing_ICD where BillingID=1000638829)
用链接取代:
select ltrim(rtrim(isnull(icddesc,'')))+'<br>'
from ref_ICD a, billing_ICD b
where a.ICDCode = b.ICDCode and b.BillingID = 1000638829
能取代的前提是:
在in 查询中,必须要有条件,就是在in中,要有一个where