need expression

[#1]

Need Help:

suppose we have two months

JANUARY     FEBURARY

1                       1

2                       2

3                       3

4                       4

                         5

having the id's i want to to compare the two months and as a result i want the new id which is in feburary but not in january as of my example which is five

i need expression for this:

[#2]

Try this

  January:

Load * inline [

January1

1

2

3

4

];

February:

Load * inline [

February1

1

2

3

4

5

];

Test:

Load January1 as January,

January1 as Month

resident January;

join load

February1 as February,

February1 as Month

reisdent February;

test1:

Load

If(February<>January,February) as newid

resident Test;

drop table Test;