Finding who doesn't sell to a certain place...

Old Pedant · December 22nd, 2010, 06:39 PM

And before you ask, let's show one more simple variation on that:

Code:

SELECT vendorName 
FROM Vendors 
WHERE vendorID IN (
      SELECT O.VendorID
      FROM Orders AS O, Customers AS C
      WHERE O.customerID = C.customerID 
        AND C.State IN('WA','OR','CA') ) 
AND vendorID NOT IN (
      SELECT O.VendorID
      FROM Orders AS O, Customers AS C
      WHERE O.customerID = C.customerID 
        AND C.State IN ('ME','NH','VT','MA','CT','RI') )

That gets all vendors who have sold in the 3 West Coast states but have never sold to any state in New England. Okay? You can see there are lots of ways to vary this.

03jh01 · December 22nd, 2010, 07:42 PM

I cannot thank you enough for helping me out here. That is just what I needed (for you to go through one of the queries step by step)!

I have been programming C# for about 5 months now, and I would call myself intermediate in that at the moment. I think I should be in a position to advance to a higher level in SQL quite quickly... I hope :).

SQL looks quite simple on the face of it, but it's not until you start properly trying to learn it that you see that that isn't necessarily always the case.

As for the queries that took up 4 to 5 pages...woah. I would love to see those! What sort of queries are they? My naive SQL mind can't even imagine what you would be querying for it to take up that many pages :).

Anyway, thanks again, you couldn't have helped me out anymore if you tried.

See you around no doubt :).

Old Pedant · December 22nd, 2010, 08:02 PM

Sorry...can't show them to you. Proprietary. Briefly, they are stored procedures (so in reality maybe 10 different queries in one?) that do statistical analysis of time series data.