子查詢

SELECT SiteName,MotAssetNumber, LocalAssetNumber, EquipmentSN, EquipmentAndModelName, Manufacturer, Expr1 AS EquipmentTypeName, EStatusDefinition, PositionOrStationName
FROM New_All_Integrate
where SiteName in (select sitename from New_All_Integrate where eid='" + eid + "') and PositionOrStationName in (select PositionOrStationName from New_All_Integrate where eid='" + eid + "')