On Feb 16, 2008, at 7:50 PM, Christopher Green wrote: > One of the things AS spoiled me with from early on is > "whose clauses" (apparently also known as the by-test > reference form). My question is, for those of you who > reeeeally know other scripting/programming languages, > what other languages have this funcionality as a basic > feature?? > > Anyone? The "WHERE" clause in SQL is essentially the same thing. SELECT lastname FROM users WHERE firstname LIKE 'Chris%' This means roughly the same thing as... get the lastname of every user whose firstname begins with 'Chris' But the thing I love about SQL is that it omits articles and copulae. I call it a Tonto language, because most statements come out sounding like that character's speech in the Lone Ranger radio and TV series. Tarzan language would be equally applicable. SQL also has a "HAVING" clause for restricting grouped data. SELECT a, sum(b) FROM thistable GROUP BY a HAVING a < 100