#sql
1 post tagged “sql”.
Displaying 1:n Data in Grid
May 11, 2008
Imagine that you have a one-to-many relationship in your database, for example, you have table person in which you keep personal data (first, middle, last names, etc.) and you have table phone where you keep phone numbers (phone type, phone number). It is quite common to have person:phones, company:phones, order:items, invoice:items, etc relationships.