34,591
社区成员
发帖
与我相关
我的任务
分享
1,一个exists和inner的语句,那个效率高呢,大家给指点一下,大家一般用的是那个啊?
--1, EXISTS sql sentence
SELECT Routing.Departure_GUID, Routing.FeederGateway_GUID
FROM Routing
WHERE EXISTS(select 1 from #DesMRoutingIDTable AddOnRouting where Routing.RoutingID = AddOnRouting.MID)
AND EXISTS(select 1 from #airpotIDTable where #airpotIDTable.aID=Routing.Departure_GUID OR #airpotIDTable.aID=Routing.FeederGateway_GUID)
--1, INNER join sql sentence
SELECT Routing.Departure_GUID, Routing.FeederGateway_GUID
FROM Routing
INNER JOIN
#DesMRoutingIDTable AddOnRouting ON Routing.RoutingID = AddOnRouting.MID
INNER JOIN #airpotIDTable ON #airpotIDTable.aID=Departure_GUID OR #airpotIDTable.aID=FeederGateway_GUID
2,还有如果我要去exists表中的数据,如何写,我想取#DesMRoutingIDTable 的ID1和#airpotIDTable的 ID2字段
SELECT Routing.Departure_GUID, Routing.FeederGateway_GUID,取(ID1,ID2)
FROM Routing
WHERE EXISTS(select 1 from #DesMRoutingIDTable AddOnRouting where Routing.RoutingID = AddOnRouting.MID)
AND EXISTS(select 1 from #airpotIDTable where #airpotIDTable.aID=Routing.Departure_GUID OR #airpotIDTable.aID=Routing.FeederGateway_GUID)
谢谢大家!