can i use join in this case?

[#1]

Hello,

Anyone can help doing the following in the script??

I have 2 tables:

table1 :

ID,Type

1,New

2,New

table2:

ID,Type

2,Review

As a result i need a table that will return:

ResultTable:

ID,Type

1,New

[hic]

Do you want to load records from table1 that are not marked as 'Review' in table 2?

If so, you could do the following:

ReviewIDs:

Load

     ID

     from table2

     where Type = 'Review';

ResultTable:

Load

     ID,

     Type

     from table1

     where not exists(ID);

Drop Table ReviewIDs;

/HIC

[adhudson]

Hi,

     Just to get confirm if I understood your requirement correctly.

     So, A values of ID can exist in both the tables and the type can be different in those tables. But the resulting table should show those ID values which has only one type value.

     Is that right?

Regards

Andrew Hudson