table one
product c
==========================================
sample_1 Line
sample_1 LLk
sample_1 LLk
sample_1 LLk
sample_1 LLk
sample_2 LLk
sample_3 LLk
sample_2 LLk
sample_3 LLk
sample_2 Line
Plus this table two
a h r
==========================================
LLk sample_1 gw
LLk sample_2 okp
LLk sample_3 ijof
Line xe rr3
LLk sample_4 gr2
Line xx2 o3
Finally will be like this..
based on searching from table 2 where a=LLk
product counts
============================
sample_1 4
sample_2 1
sample_3 2
sample_4 0