取SFC_STEP_BO关联SFC_STEP表的HANDLE,取SFC_ROUTER_BO关联SFC_ROUTER表的HANDLE,取SFC_ROUTING_BO关联SFC_ROUTING表的HANDLE,取SFC_BO关联SFC表的HANDL
时间: 2023-09-09 17:13:13 浏览: 152
E,可以使用以下SQL语句:
```
SELECT SFC_STEP.HANDLE AS SFC_STEP_HANDLE, SFC_ROUTER.HANDLE AS SFC_ROUTER_HANDLE, SFC_ROUTING.HANDLE AS SFC_ROUTING_HANDLE, SFC.HANDLE AS SFC_HANDLE
FROM SFC_BO
JOIN SFC ON SFC_BO.SFC_ID = SFC.ID
JOIN SFC_ROUTING_BO ON SFC_BO.ID = SFC_ROUTING_BO.SFC_BO_ID
JOIN SFC_ROUTING ON SFC_ROUTING_BO.SFC_ROUTING_ID = SFC_ROUTING.ID
JOIN SFC_ROUTER_BO ON SFC_ROUTING.SFC_ROUTER_BO_ID = SFC_ROUTER_BO.ID
JOIN SFC_ROUTER ON SFC_ROUTER_BO.SFC_ROUTER_ID = SFC_ROUTER.ID
JOIN SFC_STEP_BO ON SFC_STEP_BO.SFC_ROUTER_BO_ID = SFC_ROUTER_BO.ID
JOIN SFC_STEP ON SFC_STEP_BO.SFC_STEP_ID = SFC_STEP.ID;
```
这个 SQL 语句使用了多个 JOIN 操作,将多个表连接在一起,并且通过 SELECT 语句选择所需要的列。最终查询结果包含了 SFC_STEP、SFC_ROUTER、SFC_ROUTING 和 SFC 表中的 HANDLE 列。
阅读全文