I have 2 lists in SharePoint 2010. First List E lists all locations.
In the second list H I use first E list as lookup for Location. Every month users inputs information in list H.
List E has (Location)
List H has(Locations (lookup from list E), Month, Inventory, Name)
I need to know which location DID NOT provided inventory this month.
I used .net before and in SQL the statement I used was
SELECT E.Canteen_Location FROM dbo.v_Location AS E LEFT OUTER JOIN dbo.tblInventory AS H ON H.Canteen = E.CanteenNum And Month=@Month WHERE (H.Canteen IS NULL)
Now we moved to SharePoint 2010 and I do not know if this is even possible. Can somebody help me with this?