SQL Subqueries ANY ALL SOME – Thanks

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

Actually, I’ve always had the sneaky suspicion that Joe feels the QBE grid isn’t macho enough for a “real” SQL programmer!

Reply | Quote

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.

Reply | Quote

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”!)

Reply | Quote

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.

Reply | Quote

>>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…".

Reply | Quote

Have you been using Legare’s spell checker?

Reply | Quote

Good one!

Reply | Quote

—–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
—–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

Reply | Quote

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]

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

Reply | Quote