[步骤]

(@P1 datetime,@P2 datetime)SELECT "Tbl1004"."CustomerID" "Col1653","Tbl1004"."SKU" "Col1654","Tbl1004"."OrderSourceType" "Col1655","Tbl1004"."Country" "Col1656","Tbl1004"."FirstOrderTime" "Col1657","Tbl1004"."AddTime" "Col1659","Tbl1004"."ID" "Col1652" FROM "irobotbox"."dbo"."RB_FirstOrder_PatformCountry" "Tbl1004" WITH (NOLOCK) WHERE "Tbl1004"."AddTime"<@P1 AND "Tbl1004"."CustomerID"=(1) AND "Tbl1004"."IsDelete"=(0) AND "Tbl1004"."AddTime">=@P2 ORDER BY "Col1657" ASC,"Col1654" ASC

(@P1 datetime)SELECT "Col1188","Col1189","Col1135","Col1149","Tbl1008"."OrderSourceType" "Col1122" FROM "irobotbox"."dbo"."RB_OrderSource" "Tbl1008" WITH (NOLOCK) RIGHT OUTER JOIN (SELECT "Col1187","Col1188","Col1189","Col1134","Col1135","Col1137","Col1149","Col1159","Col1170","Col1192","Col1190","Col1186","Col1197","Col1200","Col1194","Col1198","Col1196","Col1195","Col1193","Col1199","Col1191","Col1148","Col1139","Col1171","Col1143","Col1138","Col1162","Col1140","Col1176","Col1158","Col1146","Col1150","Col1169","Col1164","Col1167","Col1141","Col1133","Col1168","Col1178","Col1175","Col1152","Col1151","Col1181","Col1161","Col1160","Col1147","Col1182","Col1142","Col1144","Col1145","Col1155","Col1156","Col1157","Col1153","Col1154","Col1172","Col1174","Col1179","Col1173","Col1165","Col1177","Col1180","Col1183","Col1136","Col1163","Col1166" FROM (SELECT "Tbl1006"."CustomerID" "Col1134","Tbl1006"."OrderCode" "Col1135","Tbl1006"."OrderSourceID" "Col1137","Tbl1006"."PayTime" "Col1149","Tbl1006"."OrderStatus" "Col1159","Tbl1006"."IsStockOrder" "Col1170","Tbl1006"."IsPay" "Col1148","Tbl1006"."SellerOrderId" "Col1139","Tbl1006"."IsSystem" "Col1171","Tbl1006"."AddTime" "Col1143","Tbl1006"."ClientOrderCode" "Col1138","Tbl1006"."AmazonShipmentId" "Col1162","Tbl1006"."ClientUserAccount" "Col1140","Tbl1006"."ISsynchOverseas" "Col1176","Tbl1006"."OrderState" "Col1158","Tbl1006"."WareHouseID" "Col1146","Tbl1006"."TotalPrice" "Col1150","Tbl1006"."IsFBAOrder" "Col1169","Tbl1006"."ShipTime" "Col1164","Tbl1006"."DownLoadUpdateTime" "Col1167","Tbl1006"."Email" "Col1141","Tbl1006"."ID" "Col1133","Tbl1006"."UpdateTime" "Col1168","Tbl1006"."MarkDeliveryState" "Col1178","Tbl1006"."ShareType" "Col1175","Tbl1006"."RefundPrice" "Col1152","Tbl1006"."RefundType" "Col1151","Tbl1006"."SellerUserID" "Col1181","Tbl1006"."ProductNumber" "Col1161","Tbl1006"."ServiceAdminID" "Col1160","Tbl1006"."ToWareHouseID" "Col1147","Tbl1006"."PromotionType" "Col1182","Tbl1006"."RecommendMemberID" "Col1142","Tbl1006"."TransactionId" "Col1144","Tbl1006"."TransportID" "Col1145","Tbl1006"."Country" "Col1155","Tbl1006"."Province" "Col1156","Tbl1006"."City" "Col1157","Tbl1006"."FirstName" "Col1153","Tbl1006"."LastName" "Col1154","Tbl1006"."PackagedIDs" "Col1172","Tbl1006"."IsTogeInvoice" "Col1174","Tbl1006"."IsASingleInTheEnd" "Col1179","Tbl1006"."MergeOrderCode" "Col1173","Tbl1006"."UpdatePlatformTime" "Col1165","Tbl1006"."LogisticsOrderNo" "Col1177","Tbl1006"."LogisticsOrderNo1" "Col1180","Tbl1006"."SaveTrackNumbersTime" "Col1183","Tbl1006"."MainOrderCode" "Col1136","Tbl1006"."TrackNumbers" "Col1163","Tbl1006"."TrackNumberTemp" "Col1166" FROM "irobotbox"."dbo"."RB_OrderInfo" "Tbl1006" WITH (NOLOCK) WHERE "Tbl1006"."IsStockOrder"=(0) AND "Tbl1006"."PayTime">=@P1 AND "Tbl1006"."OrderStatus"<>(2)) Qry1184,(SELECT "Tbl1004"."CustomerID" "Col1187","Tbl1004"."OrderCode" "Col1188","Tbl1004"."SKU" "Col1189","Tbl1004"."PurchaseType" "Col1192","Tbl1004"."ProductNum" "Col1190","Tbl1004"."ID" "Col1186","Tbl1004"."AddTime" "Col1197","Tbl1004"."BuyerName" "Col1200","Tbl1004"."ASIN" "Col1194","Tbl1004"."GroupSKU" "Col1198","Tbl1004"."IP" "Col1196","Tbl1004"."SellerSKU" "Col1195","Tbl1004"."OrderItemId" "Col1193","Tbl1004"."LockNum" "Col1199","Tbl1004"."ProductNumUpdate" "Col1191" FROM "irobotbox"."dbo"."RB_OrderList" "Tbl1004" WITH (NOLOCK) WHERE "Tbl1004"."CustomerID"=(1)) Qry1201 WHERE "Col1187"="Col1134" AND "Col1188"="Col1135") Qry1202 ON "Tbl1008"."CustomerID"="Col1187" AND "Tbl1008"."ID"="Col1137"

[结果]

[期望]

修改相关SQL 语句 ，提升SQL 效率，减少读库 数据库的资源消耗