Fetch the undefined values in table 1 from table 2

[Prabhu1204]

I have two tables.

Action is a static table (Below is the table)

 

Expected output
ID	Action
3	sales in progress
4	In progress

the second table should have only the values defined in the table 1. So i need to fetch the values that are not defined in the table one.

Suggestions required

[Prabhu1204]

 @sunny_talwar , can you suggest some idea

[Kushal_Chawda · Accepted solution]

@Prabhu1204  try below. make sure that field name of Action in table1 should be same as table2. If not then rename Action of Table1 as same as table2.

Table1:
LOAD Action
FROM Table1;

Table2:
LOAD ID,
     Action
FROM Table2
where not exists(Action);

drop table Table1; 

[Prabhu1204]

@Kushal_Chawda Thanks a lot Kush... Thank you so much, i never knew that i have to drop the table 1...

But one question, I dont have ID field in table 1. In that case can I use Action field instead of ID

[Kushal_Chawda]

@Prabhu1204  i meant to be action only but ID was typo

[Prabhu1204]

Thank you.. you always rock