|
|
SQL Queries for Mere Mortals
 |
| Authors: John Viescas & Mike Hernandez |
| Published by: Addison-Wesley |
| ISBN: 0-201-43336-2 |
UK Price: £??.?? |
US Price: $39.95 |
|
| This is a general database book about SQL -
Structured Query Language. Access doesn't fully support the SQL
standards (no database does fully), so parts of the book do not
apply to Access (and unfortunately there is no indication as to
which databases don't support various operations), but if you want
to know what the difference is between a LEFT OUTER JOIN and a
RIGHT OUTER JOIN is, this is the book for you. For some reason,
although there are Access sample databases supplied on the CDROM
(along with a set of databases for SQL Server 7 and a trial
version of SQL Server), they are supplied as Access 2000
databases. Access does supply a Query By Example (QBE) grid, which
is a graphical representation of the SQL, which will allow you to
construct most types of queries quickly and easily, but in order
to get the most out of a properly normalised database, it helps to
know some SQL. SQL is not a database specific language - it
applies, with varying relevance to nearly all databases - SQL
Server, Oracle, Access, dBase, so anything that you learn from
this book would apply in general to any database language,
depending on the implementation of SQL. |
|
Top
HOME |
NEW |
TABLES |
QUERIES |
FORMS |
REPORTS |
GENERAL |
API |
DOWNLOADS |
TUTORIAL |
RESOURCES
E-MAIL
Copyright & Disclaimer
|
| |
