Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

On 02/07/2012 03:06 PM, Andreas Säger wrote:
Am 07.02.2012 16:52, Jay Lozier wrote:

Most people are scared off by having to develop queries, particularly if
they must use SQL. It is too much like programming to them and that
tends to scare them; seemingly arcane rules and syntax that does not
appear very flexible or easy to use.

Some of them are so desparately trying to organize their data in spreadsheets that they start learning an extinct programming lingo together with formulas like
=IF(ISERROR(INDEX(INPUT.$A$2:$A$301;MATCH(A3;INPUT.$B$2:$B$301;0)));"";INDEX(INPUT.$A$2:$A$301;MATCH(A3;INPUT.$B$2:$B$301;0))) +IF(ISERROR(INDEX(INPUT.$A$3:$A$300;MATCH(A3;INPUT.$D$3:$D$300;0)));"";INDEX(INPUT.$A$3:$A$300;MATCH(A3;INPUT.$D$3:$D$300;0)))

The irony is that most SQL queries are easier to understand because they reference tables and columns by name (out of necessity) and usually have a selection criteria that is makes contextual sense, such as vendor name. The above is not easy to follow or debug, I know because I do similar in the past.

SELECT    column names
FROM    table
WHERE    criteria for selection

is easier to follow, even when the query is much more complex

Jay Lozier

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.