UnfamiliarTerritory.net

Using MySQL’s Case Statement for Mapping result sets between tables

Tuesday, May 20th, 2008 Posted in Programming | No Comments »

I had a group of tables that were originally supposed to be very different from each other. The tables held registration data for a group of events my company was marketing. At the start of the project, I asked if the information requirements for the various registration forms would differ significantly. Naturally, thinking each event was unique and special, the account reps told me that each of the event registration forms would collect information relating to the event in some ...