Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>Hello Tamar,
>
>This past weekend I was banging my head (figuratively) against a particularly gnarly SQL SELECT statement that denormalizes poorly normalized FP/DOS data for a VFP9 report cursor. Thanks to Chapter 4, I was able to take a bit of knowledge gained from your presentation at a Chicago FUDG meeting last year, and lock in the proper use of a sequential LEFT JOIN with three tables. The real gem (page 47) was figuring out that one of the WHERE conditions was filtering out records from the two JOINed tables that I really wanted - moving the condition to the ON clause fixed the problem; and there was great rejoicing at the keyboard!
>
>Morals of the story: Attend User Group meetings.- Buy the books - Attend a conference. It all really makes a difference in development.
>
>Thanks very much for your contributions to the community,
You're welcome and thanks so much for letting me know.
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement