gettruckload.sql

来自「微软的行业应用解决方案示例」· SQL 代码 · 共 5 行

SQL
5
字号
SELECT Trucks.TruckId, Trucks.LicensePlateStateProvince, Trucks.LicensePlateNumber, Trucks.RouteId
FROM Orders, Customers, Trucks
WHERE Orders.OrderId = @orderId AND
      Orders.CustomerId = Customers.CustomerId AND
      Customers.RouteId = Trucks.RouteId

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?