Need to edge out the competition for your dream job? Train for certifications today.
where did the o .customerid come from?
Dim query = From a In db.Table1 _
Where a.Letter = "y" AndAlso Not (From b in db.Table2 _
Where b.fk_Planid = "30" _
Select b.ProductServiceName).Contains(a.Product_ProductServiceName) _
Select New With _
a.ProductServiceName = Product_ProductServiceName, _
a.ProductClass = ProductClass _
Open in new window
var query = from a in db.Table1
where a.Letter == "y" && !(from b in db.Table2
where b.fk_Planid == "30"
ProductServiceName = Product_ProductServiceName,
ProductClass = ProductClass
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.