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, ...
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 ]