« first day (1421 days earlier)      last day (3265 days later) » 

2:59 AM
@thePetProjectProgrammer I cannot recommend a book, but I suggest going to your closest Barns and Nobel and looking at O'Reilly or Wiley Press books. These are two of the best publishers. There is one other I like a lot too, but I cannot think of the name right now. Between these two, there are no "dummy" books in their line-up. These are heavy hitters.
-- I am stuck on what should be a simple(ish) query. The scenario (schema wise) is really really simple. I just cannot get my head around how to do it. Is there a SQL expert out there to take a crack at it?? Two tables- one is a simple join table with ids only. I want the ip address and ip address id frim ipaddress table where ip address id exists in join table along with the count of how may times the ip address id appears in the join table.
This is part of my stability algo- I could write it in code, but it would be nice to have a single result table to work from. Flag me if you can help.
 

« first day (1421 days earlier)      last day (3265 days later) »