回答：自己搞定了，在取数据这块直接用sqlserver的sp_addlinkedserver和sp_addlinkedsrvlogin加到一起去查
回答：自己解决了 还是改了sql写法算了，用UNION ALL来区分从哪个表取的数据，待验证中。。select '入场' as 出入场类型,car_no,(
CASE
WHEN income_record_cloud.card_type_id = '7' THEN
'员工卡'
WHEN income_record_cloud.card_type_id = '8' THEN
'商户卡'
WHEN income_record_cloud.card_type_id = '11' THEN
'临时车' ELSE '未知车辆类型'
END
) AS 车辆类型,(
CASE
WHEN income_record_cloud.iogate_id BETWEEN '1'
AND '3' THEN
'北门'
WHEN income_record_cloud.iogate_id BETWEEN '4'
AND '6' THEN
'南门'
WHEN income_record_cloud.iogate_id BETWEEN '7'
AND '8' THEN
'西门' ELSE '其他门'
END
) AS 入口
from income_record_cloud
UNION all
select '出场' as 出入场类型,car_no,(CASE
WHEN outcome_record_cloud.card_type_id = '7' THEN
'员工卡'
WHEN outcome_record_cloud.card_type_id = '8' THEN
'商户卡'
WHEN outcome_record_cloud.card_type_id = '11' THEN
'临时车' ELSE '未知车辆类型'
END
) AS 车辆类型,(
CASE
WHEN outcome_record_cloud.iogate_out_id BETWEEN '1'
AND '3' THEN
'北门'
WHEN outcome_record_cloud.iogate_out_id BETWEEN '4'
AND '6' THEN
'南门'
WHEN outcome_record_cloud.iogate_out_id BETWEEN '7'
AND '8' THEN
'西门' ELSE '其他门'
END
) AS 入口 from outcome_record_cloud
回答：自己找到问题了，是泛微数据库字段的问题
3
3
6
10
没有更多
