MySQL Forums :: Database Design & Data Modelling :: User-friendly approaches to displaying subtable data


Advanced Search

User-friendly approaches to displaying subtable data
Posted by: Colleen Boye ()
Date: June 21, 2013 08:18PM

This is just a general database design question.

When you select from tables with a one-to-many relationship using a left join, SQL displays a separate line (containing all the data from the left-hand table) for each item from the right-hand table. So in my database, where there are records that can be assigned many locations, you get something like:

Record Number|Location
----------------------
1            | Loc1
1            | Loc2
1            | Loc3
2            | Loc1
2            | Loc4

Of course this is correct database behavior, but I imagine it tends to throw users for a loop and result in a lot of "Why is this record listed multiple times?" questions if it's displayed like that. So what are some ways that one handles data to make it less confusing to users?

Options: ReplyQuote


Subject Written By Posted
User-friendly approaches to displaying subtable data Colleen Boye 06/21/2013 08:18PM
Re: User-friendly approaches to displaying subtable data Rick James 06/23/2013 12:47AM
Re: User-friendly approaches to displaying subtable data Colleen Boye 06/24/2013 04:37PM
Re: User-friendly approaches to displaying subtable data Rick James 06/25/2013 10:12PM
Re: User-friendly approaches to displaying subtable data Colleen Boye 07/22/2013 05:06PM
Re: User-friendly approaches to displaying subtable data Rick James 07/23/2013 09:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.