ID数据类型搞错,假设两张表
create table TABLE1
(
id VARCHAR2(30),
)
create table TABLE2
(
id NUMBER(10) not null,
id_TABLE1 VARCHAR2(30),
name VARCHAR2(30),
)
插数据
insert into TABLE1 (ID) values ('A');
insert into TABLE2 (ID, ID_TABLE1, NAME) values (1, 'A', 'A');
万一我写成了:
SELECT
T2.NAME
FROM TABLE2 T2
LEFT JOIN TABLE1 T1
ON T1.ID = T2.ID
就马上报了无效数字,搞错 ID 查半天