How to exclude data

[#1]

Hi,

I have two tables:

MainTable:

MemberId

1

2

3

ExcludeTable:

MemberId

1

How to use script to exclude memberid 1?

I just want to get 2,3

Thanks.

[pover]

Use the exists() function.

ExcludeTable:

Load MemberId as MemberId_Exclude
From ExcludeTable;

MainTable:

Load MemberId
From MainTable
Where not exists(MemberId, MemberId_Exclude);

Regards.

[#3]

Hi,

But I use SQL not load, how can I use Exist function?

SQL select MemberId as ExcludeMemberId
FROM Test.dbo.ExcludeMember;

SQL select MemberId
FROM Test.dbo.MemberId
;

[#4]

you can use this as your basis:

LOAD *,

if(Exists(Field1,Field2),Field2)

Resident TableName;

[Anonymous]

Nothing prevents you from using preceding load:

ExcludeTable:
SQL select MemberId as ExcludeMemberId
FROM Test.dbo.ExcludeMember;
MainTable:
LOAD MemberId
Where not exists(MemberId, MemberId_Exclude);
SQL select MemberId
FROM Test.dbo.MemberId;

[#6]

Sorry, what's the meaning of ' MemberId_Exclude'?

[#7]

thats the alias of the MemberId you loaded from

Test.dbo.ExcludeMember