IN addition to the previous post, this is the sql query im trying to get fomr using the selected items from a dataviewGrid to get the array of partID to us to restrict the query to only vendors that don;t have an existing many to many relation to the part. seems simple in SQL

  the 1,8,12,15 is the partID collected from the selected Item of a dataviewGrid as a collection of Parts (partsCollection)

Code:

SELECT * FROM Vendor
WHERE VendorID NOT IN(select VendorID from partvendor
Where PartID IN (1,8,12,15)
)

Code:

EmployeesQuery sub = new EmployeesQuery();
sub.Select(sub.EmployeeID);
sub.Where(sub.EmployeeID.In(1, 8, 12, 15));

EmployeesQuery main = new EmployeesQuery();
main.Where(main.EmployeeID.NotIn(sub));

EmployeesCollection coll = new EmployeesCollection();
coll.Load(main);

This generates this SQL

Code:
SELECT * FROM [Employees] 
WHERE [EmployeeID] NOT IN 
(
    SELECT [EmployeeID] AS 'EmployeeID' FROM [Employees] 
    WHERE [EmployeeID] IN (1,8,12,15)
)