All Joe Celkos books are good, real-world type SQL books. "SQL for Smarties" is excellent too. He has a new book and trees and hierarchy in SQL coming out soon too.
-----Original Message----- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 16:05 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] one-to-one relationship Thanks Colm - that has good reviews on Amazon - I might get that _______________________________________________________ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 _______________________________________________________ -----Original Message----- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 16:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] one-to-one relationship 'Database Design for Mere Mortals', Hernandez, good for pondering these issues -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 31 October 2003 15:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] one-to-one relationship No.... he's right -- you need a table per entity but with an intermediary table binding teams to pitches Teams TeamID Team etc | TeamPitches TeamID PitchID | Pitches PitchID etc That gives you the flexibility to handle teams that share pitches. Obviously, put a uniqueness constraint on TeamID-PitchID in the intermediary table. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] ======================================================= This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ======================================================= -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
