Need help with a sql view
Posted on 2012-08-16
I am using the following query:
SELECT a.pkNewTargetID, a.ProductClass, a.Product_ProductServiceName
FROM Target AS a LEFT OUTER JOIN
TargetReference AS b ON a.Product_ProductServiceName = b.ProductServiceName amd b.fk_PlanID='30'
WHERE (b.ProductServiceName IS NULL) AND (a.Letter = 'Y')
This query is intended to show all records from target that are not in TargetReference that are assigned to that paticular fk_PlanID. I can get the query to work in design view however when I put it into a view I cannot populate that '30' using a linqdatasource. Please help.