Perfect. Thanks ... View more

@abidgoliwb - this forum does not work well with "followup questions" that add new items after the question is solved - you will end up waiting for an original answerer who may not log on for days. It's best to write up the new question, with all the information needed to understand what is being asked, and include a reference to the prior answer. I believe you are looking for | inputlookup table1 | join type=inner max=0 keyfield [ inputlookup table2] | lookup table3 keyfield OUTPUT keyfield AS foundit | where isnull(foundit) ... View more