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