i have two flat file and it contain common one column values is equal to two flat file. so normally we using inner join and retrieve data, but here my scenario not equal to be display in the report?. If anyone known this answer help to me.
LOAD your first file and your FirstField (common ?)
CommonField as newField
FROM your second fileWHERE not exists(FirstField, NewField)
Retrieving data ...