[thelist] MySQL Select from multiple tables - have I gotitright?

[Joel D Canfield]

> I'm kind of waffling.

mmmm . . . waffles . . . 

> I agree that if Chris has five tables with identical structures he
> should be able to collapse those into a single table and that 
> the single
> table would be easier to work with.
> 
> However ... we really don't know very much about what Chris 
> is trying to
> do.  Nor do we know what these 'event categories' are.  If the events
> are disparate enough then perhaps they ought to have different table
> structures. [1]
> 
> With the limited scope of information provided I think the answer is
> good.  Just noting that what we are suggesting here may turn 
> out to be a
> temporary or a suboptimal solution that eventually paints Chris into a
> corner.  'Quick & Dirty' database design often leads to considerable
> time and pain later.
> 
> Cautiously,
> RonL.
> 
> [1] Being the 'imaginative' sort, I imagined Chris's "events" to be
> various fundraisers all supporting a common charity.  A band 
> plays a pro
> bono dance.  A multi-site softball tournament with entry fees is held.
> A magician gives numerous performances during a community bazaar.  A
> multi-week 'football pool' event is also held.  Etc.  A 
> single table (or
> a single table structure) may not be the best way to
> capture/report/present information for each or all of these individual
> events.
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 
> No virus found in this incoming message.
> Checked by AVG Free Edition. 
> Version: 7.5.467 / Virus Database: 269.7.1/805 - Release 
> Date: 5/15/2007 10:47 AM
>  
> 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007 10:47 AM