如果要查看数据，可以执行以下操作：

select "Condition 1" as condition
     , SystemName
     , AssetName
     , Table1.ReconID as "Table1_ReconID"
     , Table2.ReconID as "Table2_ReconID"
from Table1, Table2
where SystemName = AssetName AND Table1.ReconID <> Table2.ReconID
union 
select "Condition 2" as condition
     , SystemName
     , AssetName
     , Table1.ReconID as "Table1_ReconID"
     , Table2.ReconID as "Table2_ReconID"
from Table1, Table2
where SystemName <> AssetName AND Table1.ReconID = Table2.ReconID
union
select "Condition 3" as condition
     , SystemName
     , AssetName
     , Table1.ReconID as "Table1_ReconID"
     , Table2.ReconID as "Table2_ReconID"
from Table1, Table2
where SystemName = AssetName AND Table1.ReconID = Table2.ReconID
order by condition

在交叉的情况下，使用“union all”而不是“union”。