> Have you tried it on some other SQL-92 compliant DB and had it work? I've > never seen "all" used in quite that way before. Admittedly, I've only used > SQL Server, Oracle, MSDE, Access and now SQLite, so maybe that's just me.
I'm actually taking these examples from my database textbook (Database
System Concepts 4th Edition). It's a section on Set Comparisons where
and it says you can use < all, <= all, >= all, and = all. The example
they give is:
"Find the names of all the branches that have an asset value greater
than that of each branch in Brooklyn."
select branch-name
from branch
where assets > all (select assets
from branch
where branch-city = 'Brooklyn')
> If you check out the relevant section of the "SQL as Understood By SQLite",
> http://www.sqlite.org/lang.html#select, you'll see that the use of the "all"
> keyword is somewhat different from what you've used.
That link clears up why it was failing.
Thanks for your time, and pardon my SQL ignorance. I'll still quite a
newbie. :-)
-Evan
--
/********************************************************************\
Evan McNabb: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
http://evan.mcnabbs.org
System Administrator, CS Department, BYU
GnuPG Fingerprint: 53B5 EDCA 5543 A27A E0E1 2B2F 6776 8F9C 6A35 6EA5
\********************************************************************/
pgp00000.pgp
Description: PGP signature
