Table not found error when loading data

[theboss-123]

Hello,

Please should be informed that when i tried to load data from tables usinginner join i got the below error

Table not found error

Table 'STOLOT' not found

inner join(STOLOT)
Load
ITMREF_0,
ITMDES1_0

and here is my script

SQL SELECT *
FROM sagex3lab.SEED.STOJOU;

Inner join(STOJOU)

Load
ITMREF_0,
LOT_0,
SLO_0;

SQL SELECT *
FROM sagex3lab.SEED.STOLOT;
inner join(STOLOT)
Load
ITMREF_0,
ITMDES1_0;

SQL SELECT *
FROM sagex3lab.SEED.ITMMASTER;
//-------- End Multiple Select Statements ------

[Chanty4u]

instead of innerjoin can you try with " 

NOCONCATENATE 

[theboss-123]

Thanks for your reply can you show me where i can put on the script "NOCONCATENATE"

[theboss-123]

it is working thank you 

[theboss-123]

it is loading data but data not correct

[slsaagar]

Try this

Temp:
SQL SELECT *
FROM sagex3lab.SEED.STOJOU;

Inner join(Temp)

Load
ITMREF_0,
LOT_0,
SLO_0;

SQL SELECT *
FROM sagex3lab.SEED.STOLOT;
inner join(Temp)
Load
ITMREF_0,
ITMDES1_0;

SQL SELECT *
FROM sagex3lab.SEED.ITMMASTER;

[theboss-123]

that is work but im unable to add date calendar

Load 

ACCDAT_0

Date(ACCDAT_0) As Date,
        Year(ACCDAT_0) As Year,
        Month(ACCDAT_0) As Month,
        Day(ACCDAT_0) As Day,
        Week(ACCDAT_0) As Week,
        'Q' & Ceil(Month(ACCDAT_0)/3) As Quarter,
        WeekYear(ACCDAT_0) & Num(Week(ACCDAT_0), '00') As YearWeek,
        Year(ACCDAT_0) & '-Q' & Ceil(Month(ACCDAT_0)/3) As YearQuarter,
        Date(MonthStart(ACCDAT_0), 'YYYY-MM') As YearMonth,
        -Year2Date(ACCDAT_0) As YTD_Flag,
        -Year2Date(ACCDAT_0, -1) As LYTD_Flag;

[QFabian]

Hi @theboss-123 , check this please , i just aded the resident clause:

Load 

ACCDAT_0,

Date(ACCDAT_0) As Date,
        Year(ACCDAT_0) As Year,
        Month(ACCDAT_0) As Month,
        Day(ACCDAT_0) As Day,
        Week(ACCDAT_0) As Week,
        'Q' & Ceil(Month(ACCDAT_0)/3) As Quarter,
        WeekYear(ACCDAT_0) & Num(Week(ACCDAT_0), '00') As YearWeek,
        Year(ACCDAT_0) & '-Q' & Ceil(Month(ACCDAT_0)/3) As YearQuarter,
        Date(MonthStart(ACCDAT_0), 'YYYY-MM') As YearMonth,
        -Year2Date(ACCDAT_0) As YTD_Flag,
        -Year2Date(ACCDAT_0, -1) As LYTD_Flag

Resident Temp;

[theboss-123]

it said the error below

Table not found error

Table 'Temp' not found

Load

IPTDAT_0,