What you probably want to do is go to amazon, and get these two books:
"The Practical SQL Handbook"
"The Practical SQL Handbook: The Sequel."
These two books are on general DB design issues, and discuss
normalization in depth. I have them, and enjoy them very much.
And as for your query, you might look at LEFT JOINs.
Here are links:
http://www.amazon.com/exec/obidos/ASIN/0201447878/qid=1028051191/sr=8-1/ref=sr_8_1/103-4096381-4279056
Hope this helps.
Quinten Steenhuis wrote:
<snip>
--
Gabriel Cain
Unix Systems Administrator [EMAIL PROTECTED]
Dialup USA, Inc. 888-460-2286 ext 208
Faster, Better, Cheaper: Pick any two.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
