var orderList = from o in order
join c in customer on o.cusid equal c.cusid
join p in product on o.proid equal p.proid
where c.cusname.contain("Insert Customer Name Here")
select new
{
orderid = o.orderid,
orderdate = o.orderdate,
cusname = c.cusname,
proname = p.proname
};