Results 1 to 11 of 11
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    For a pure SQL book, I've found Joe Celko's "Instant SQL Programming" to be useful. Be advised, however, that this is not an Access SQL book; in fact Joe is very anti-Access as it relates to the Access implementation of SQL. It does include some optimization tips. However, one of the best tips is to make sure you have indexed those fields that are commonly used in WHERE and ORDER BY statements.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Subqueries (ANY ALL SOME)

    I agree. Joe Celko is definitely the SQL guru, although a large amount of what he describes isn't supported in Access SQL, at least through Access 97. There's more support in Access 2000, and I understand that XP extends that support even further.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    Actually, I've always had the sneaky suspicion that Joe feels the QBE grid isn't macho enough for a "real" SQL programmer!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Subqueries (ANY ALL SOME)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> I think you're right! He even scorns its equivalent in products like SQL Server. But then, he gets into some pretty esoteric SQL that doesn't really lend itself to the query grid in anything. I've got about 3 of his books, and I admire his expertise, but I tend to be intimidated by it. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    I've got the "Instant SQL programming" book, and it doesn't get too much into the esoteric side. It's a good "fundamentals" book; at least it was for me.

    Joe used to visit the Compuserve Access forum frequently, and he would periodically jump all over someone about Access SQL. Sort of a right of passage in the forum! (I called it "being Celkoed"!)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Subqueries (ANY ALL SOME)

    That one isn't as exotic as some of his others. Isn't that the one that originally came with a runtime version of MySQL? In any case, he denegrates any version of SQL that doesn't support the full standard, and Access SQL has some of its own features that are non-standard plus it doesn't support all the predicates, etc. He's a purist in an impure world. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    >>That one isn't as exotic as some of his others. Isn't that the one that originally came with a runtime version of MySQL? <<

    Yes it is. And my previous post should read "..rite of passage...", not "...right of passage...". <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL Subqueries (ANY ALL SOME)

    Have you been using Legare's <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=lounge&Number=58482&pag e=0&view=collapsed&sb=5&o=186&part=>spell checker</A>? <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    Good one!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  10. #10
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Subqueries (ANY ALL SOME)

    This one may seem beneath the current standards, but I found the Sam's teach yourself SQL in 21 days method (third edition), to be easy to read yet broad in it's spectrum of coverage.

    Warning: It's not Access-based and basically favors the Oracle flavor of SQL.[ i.e No QBEs]
    <img src=/S/cauldron.gif border=0 alt=cauldron width=20 height=20>

    The topics are covered well, but don't expect to lift and drop code.

  11. #11
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Subqueries ANY ALL SOME - Thanks

    -----Added Note-----
    Thanks everyone,

    I was looking for Access SQL specific stuff as I know it has some "proprietary" features to it. Judging by the thread, I guess I'll be careful what I ask <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>
    -----End of Note-----

    Is there a good reference out there on using SQL statements in Access, with info or tips on optimizing queries to run their fastest?

    Does anyone have a good explanation of the ALL predicate?

    TIA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •