Outer join

[Carlaf_93]

Good morning,

i've got two table.

TABLE1:

LOAD * INLINE [

YEAR, MONTH, VALUE, ID,

2023,1,20,LOLP,

2023,1,34,LOLF,

2023,2,20,LO4P,

2023,2,60,LO4Y];

TABLE2:

LOAD * INLINE [

YEAR, MONTH, VALUE, ID,

2023,2,20,LO4P,

2023,2,60,LO4Y,

2023,3,20,LO4R,];

I want to create a new table that takes only the different values that are only present in table 1.

So a table with:

YEAR, MONTH, VALUE, ID,

2023,1,20,LOLP,

2023,1,34,LOLF

I tryed with outer join but it doesn't work.

Thanks

C

[Or]

That doesn't look like an other join scenario at all... perhaps a Not Exists scenario?

Table2:

Load ID from Table2;

Table1:

Load * From Table1

Where Not Exists(ID);

Drop Table Table2;

[Carlaf_93]

thanks but this solution doesn't work.

[Or · Accepted solution]

This is the result, so it seems to be working just fine...?