[AccessD] SQL, books and subqueries (was: select most recent)

Hi Eric

If you search the archive for "subquery" you'll find at least one
message.

As for books, I've stored these references:

Arthur Fuller .. two books by Joe Celko that he highly recommended:

  SQL for Smarties - ISBN 1-55860-323-9
  SQL Puzzles and Answers ISBN - 1-55860-453-7 (Advanced)

Also:

  Jim Melton and Alan R.Simon:
  SQL: A complete guide
  Morgan Kaufmann Publishers

/gustav


> Wow! It's like magic. I would never have come up with this, especially
> the part "TerritoryID=T1.TerritoryID". I still don't really understand
> how it works. I've looked through all my books, but it seems my library
> needs another book (to the astonishment of my wife!) Will you please
> suggest a book that explains this type of query?