我有两张桌子,vessel_details和vessel_history。这两个表具有相同的字段。我必须比较所有字段的值,并选择具有不同值且不为空的列。例如ship_name的字段,我必须检查vessel_details表中的字段ship_name的值是否与vessel_history表中的ship_name不同。如果值不同且不为空,则必须从vessel_history中选择并显示该值。
对正确的查询有什么想法吗?谢谢。
发布于 2014-07-11 14:05:35
SELECT vessel_details.<your_id>, 'Difference in Column ship_name for ship_name = ' + vessel_history.ship_name
FROM vessel_details
JOIN vessel_history ON vessel_details.<your_id> ON vessel_history.<id_from_vessel_details>
WHERE vessel_details.ship_name <> vessel_history.ship_name
UNION
SELECT vessel_details.<your_id>, 'Difference in Column ship_model for ship_model = ' + vessel_history.ship_model
FROM vessel_details
JOIN vessel_history ON vessel_details.<your_id> ON vessel_history.<id_from_vessel_details>
WHERE vessel_details.ship_model <> vessel_history.ship_model
.
.
.对于要检查的所有列,依此类推。
这就是你要找的吗?
为每个项目编辑一行:
SELECT vessel_details.<your_id>,
CASE WHEN vessel_details.ship_name <> vessel_history.ship_name THEN Convert(bit, 1) ELSE Convert(bit, 0) END AS ship_name_different,
CASE WHEN vessel_details.ship_model <> vessel_history.ship_model THEN Convert(bit, 1) ELSE Convert(bit, 0) END AS ship_model_different
FROM vessel_details
JOIN vessel_history ON vessel_details.<your_id> ON vessel_history.<id_from_vessel_details>
WHERE vessel_details.ship_name <> vessel_history.ship_name
OR vessel_details.ship_model <> vessel_history.ship_modelhttps://stackoverflow.com/questions/24690939
复制相似问题