use SQVI to display table join
to Table use Join display
2023-09-14 09:02:50 时间
Created by Jerry Wang, last modified on Jun 09, 2014
-
tcode SQVI:
点Create button创建一个新的QuickView:
-
Insert table:
load product table之后界面如下:
- load product description table:
这两个table 自动通过foreign key 关联起来:
将右边的Available fields移到左边的display fields里:
- 点execute button进行测试:
相关文章
- 【原创】ERROR 1142 (42000): command denied to user 引发的权限不足问题[亲测有效][通俗易懂]
- ORA-01653: unable to extend table string.string by string in tablespace string ORACLE 报错 故障修复 远程处理
- ORA-01764: new update value of join is not guaranteed to be unique ORACLE 报错 故障修复 远程处理
- ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB ORACLE 报错 故障修复 远程处理
- ORA-24356: internal error while converting from to COBOL display type. ORACLE 报错 故障修复 远程处理
- ORA-29340: export file appears to be corrupted: [string] [string] [string] ORACLE 报错 故障修复 远程处理
- ORA-30377: table string.MV_CAPABILITIES_TABLE not found ORACLE 报错 故障修复 远程处理
- ORA-42025: redefinition of CONS_USE_ROWID method cannot be used to redefine an AQ IOT table ORACLE 报错 故障修复 远程处理
- MySQL Error number: 3788; Symbol: ER_RPL_ENCRYPTION_FAILED_TO_ROTATE_LOGS; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-010383; Symbol: ER_FAILED_TO_DELETE_FROM_GTID_EXECUTED_TABLE; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-01884: divisor is equal to zero ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-011007; Symbol: ER_DD_UPGRADE_FAILED_TO_CREATE_TABLE_STATS; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-03233: unable to extend table string.string subpartition string by string in tablespace string ORACLE 报错 故障修复 远程处理
- MySQL Error number: MY-011220; Symbol: ER_AUDIT_LOG_FILTER_FAILED_TO_UPDATE_TABLE; SQLSTATE: HY000 报错 故障修复 远程处理
- MySQL Error number: MY-011251; Symbol: ER_PLUGIN_COMMON_FAILED_TO_OPEN_TABLE; SQLSTATE: HY000 报错 故障修复 远程处理
- ORA-09709: soacon: failed to accept a connection. ORACLE 报错 故障修复 远程处理
- ORA-14757: Table is already a range partitioned table ORACLE 报错 故障修复 远程处理
- ABAP：区别CALL SCREEN/SET SCREEN/LEAVE TO SCREEN详解编程语言