invalid column name in SQL SERVER
Database Subsetter and Relational Data Browser
Brought to you by:
rwisser
Insert into
JAILER_ENTITY (r_entitygraph, PK0, birthday, type)
Select
distinct 25852 as graph_id,
B.T01id as PK0,
2 as birthday,
58 as type
From
T01 B
left join JAILER_ENTITY Duplicate on Duplicate.r_entitygraph = 25852
and Duplicate.type = 58
and Duplicate.PK0 = B.T01id
and Duplicate.PK1 is null,
S03 A,
JAILER_ENTITY E
Where
(
E.r_entitygraph = 25852
and E.birthday = 1
and E.type = 53
and E.PK0 = A.S03id
and E.PK1 is null
)
and Duplicate.type is null
and (A.s03id = B.s03codTipoAppT01)
Anonymous
What the problem here?