select *
from organization o,customer c
where c.customer_square=o.structid
customer_square是nvarchar类型,structid是numeric类型。求大神啊!!在线等!
SQL
------解决方案--------------------
select *
from organization o,customer c
where c.customer_square= convert(nvarchar(10),o.structid)