score:3

Accepted answer
var _result =   (from a in product_master
                join b in product
                    on a.product_id equals b.product_id
                where b.buyer_user_id == 12
                select a).distinct();

score:0

var pids = product.where(p => p.buyer_user_id == 12);
var r = product_master.where(pm => pids.contains(pm.product_id));

Related Query

More Query from same tag