Also in aboutSQL: We've spent quite a few columns working
through the SQL SELECT statement, and you may be thinking it's
time for a break -- you're right! For the next few columns, I'm
going to back up and introduce you to database design --
specifically database keys and table relationships. After we're
done with that, we'll jump back into ... you guessed it! The
SELECT statement. But by then you'll have the tools to seriously
take a look at how to join tables together. So sit back, relax,
and get ready to be given the "key" to understanding SQL. Even
though the focus of this column is SQL, it's difficult to
discuss SQL without at least touching on basic database design
and structure. We've discussed using SQL WHERE clauses to filter
DELETE statements, but we haven't spent a lot of time discussing
how to operate on single database records using those
statements. There's no fundamental difference between using SQL
to filter a single database record and using a broader filter,
something like WHERE STATE='VA'.