Left Outer join - only rows from the left table , in splunk

[aayushisplunk1]

Is it possible to implement LEFT OUTER JOIN where only rows from the left table are fetched (NOT the Common values)?

Consider the example as given below:

Table A:

email@xxx |........
abcd@xxxx |........
efgh@xxxx |........
xyza@xxxx |........

Table B:

email@xxx|........
ijk@xxxx |........
xyza@xxxx |........

Required output table: Table C:

email@xxx |.........
abcd@xxxx |........
efgh@xxxx |........

My Query:

mysearch1
| table email@xxxx, ....
| join type=left email@xxx
[ search mysearch2
| table email@xxxx , ...]
| table email@xxx, ...

[jitendragupta]

Plz check this output, this is as per your requirement:

| makeresults |  eval id="abcd@xxxx" | append  [| makeresults |  eval id="efgh@xxxx"] |  append  [|  eval id="xyza@xxxx"] 
|  table id 
|  join type=outer id![alt text][1]  [ | makeresults |  eval id="ijk@xxxx" | append  [| makeresults |  eval id="xyza@xxxx"]  |  table id ]