Thread: Help collating multiple records from multiple tables into a single record

Oh believe me... I know. I unfortunately joined the team late... this also means I'm not allowed to change what the previous developer did. So what you're telling me - if I understand - is I need to go outside let out a primal scream and handle this outside of a SQL query. Thank you for replying.

Quote: Originally Posted by oorin This table was designed to allow a web site administrator a high level of configuration for collecting data. while at the same time no consideration for how hard it would be to extract meaningful information do a search for EAV (entity-attribute-value) you will find a litany of woe, and warnings from experienced database designers to avoid this scheme if possible you're gonna have to write some pretty...