var query = from p in Db.GetCompanyCollection<AwardProviderProduct>(companyIdentifier).AsQueryable()
                join o in Db.GetGlobalCollection<Product>() on p.Sku equals o.Sku
                where p.Reference[ProductReferenceType.AwardchoiceSource.ToString()] == "NORC"
                select new AwardProviderProduct()
                {
                  
                    Sku = p.Sku,
                  
                };

db['terryberry-AwardProviderProduct'].aggregate(
[
{ "$lookup" : { "from" : "Product", "localField" : "Sku", "foreignField" : "Sku", "as" : "o" } }, 
{ "$unwind" : "$o" },
{ "$project" :
{
     "Sku" : "$Sku"
}
}       
,
{"$match" : { "Reference.AwardchoiceSource" : "NORC" }} ])