GRAD_RESULT AS
(
SELECT IDNO,FNAME,LNAME,CODE1,LEVEL1,
TRANCODE,DESCPN,CATEGORY,
VALUE1,FPVALUE,BASWAGCON,
TAXSTATUS,SSFCAL,
DMPERCENT,DESCPTN,
SPEC_TIME,STAT_MTH,
STAT_YR,END_MTH,END_YR
FROM GRAD_MOLD
WHERE
(IDNO + LTRIM(TRANCODE)) NOT IN
(SELECT (IDNO + LTRIM(TRANCODE)) FROM XTRANS_COMB WHERE CATEGORY=[UNIQ])
),
What am I doing wrong
What I have tried:
This is a program under development with this requirement.