X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=doc%2Fcsql.xml;h=272c62536b0674330ef0e90f4cfd0bd74c741ab5;hp=814b7f4188f848a02a262120e02fc18e19e99296;hb=fc58e4fb7d908985389c86adf57ddee6c1dde5d2;hpb=2949884623a44f1866a383fb74a88aada9fced93 diff --git a/doc/csql.xml b/doc/csql.xml index 814b7f4..272c625 100644 --- a/doc/csql.xml +++ b/doc/csql.xml @@ -83,7 +83,7 @@ + url="http://philip.greenspun.com/sql/data-modeling.html"> Philip Greenspun's "SQL For Web Nerds" - Data Modeling @@ -300,7 +300,7 @@ mapped into a database). They would be defined as follows: In an &sql; only application, the EMPLOYEE and COMPANY tables can be queried to determine things -like, "Who is Vladamir's manager?", "What company does Josef work +like, "Who is Vladimir's manager?", "What company does Josef work for?", and "What employees work for Widgets Inc.". This is done by joining tables with an &sql; query. @@ -316,12 +316,12 @@ SELECT first_name, last_name FROM employee, company -Who is Vladamir's manager? +Who is Vladimir's manager? SELECT managerid FROM employee - WHERE employee.first_name = "Vladamir" + WHERE employee.first_name = "Vladimir" AND employee.last_name = "Lenin" @@ -489,7 +489,7 @@ any other CLOS object: (defvar employee1 (make-instance 'employee :emplid 1 - :first-name "Vladamir" + :first-name "Vladimir" :last-name "Lenin" :email "lenin@soviet.org" :companyid 1))