Hi,
I have two search queries which results in table as follow:
| search query1
| table type1 platform1 target1
type1
platform1
target1
X
WIN
path/cpp
X
None
pat...
See more...
Hi,
I have two search queries which results in table as follow:
| search query1
| table type1 platform1 target1
type1
platform1
target1
X
WIN
path/cpp
X
None
path/c
X
LINUX
path/py
| search query2
| table type2 platform2 target2
type2
platform2
target2
Z
WIN
path/cpp
Z
LINUX
path/cpp
(Target are unique based on their full path)
How I can compare both tables . by making left join between both tables and comparing, such that :
-> join both tables where first query table is the lead when comparing against, left join I believe ?
-> Count as match only IF target from first query where platform = WIN , exists in second table where platform = WIN
-> Count as match only IF target from first query where platform = LINUX, exists in second table where platform = LINUX
-> Count as match only IF target from first query where platform = NONE, exists in second table for both platform = LINUX and platform = WIN else no match
Then list results in table with total matching target, total missing target, total target for type X , total target for type Z .
How I can reach this ?
Thanks