• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Parent child join query

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I have a parent table and a child table with one-to-many relationship. Each parent record is related to one or more child records.

For example each record in PEOPLE (parent table) has one or more records in PHONE (child tables).

I have an application which generates an XML file from the result object returned from the PEOPLE table. The structure of the output is like



If I run a simple query on the PEOPLE table due to the association with the PHONE table, it runs a series of associated select on the child tables. To avoid this I make use of from the parent table onto the child table. But when I run this query I get duplicated entries for each record which has more than one phone number.

I think I have to make use of tuple queries to remove this duplication in results, but not sure how to do it. Can anyone suggest me the approach to do it.

thanks in advance
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please post your mapping files, and your code for the query.

Mark
 
Raaj Aaryan
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Here is the mapping file of the parent table


and the query is



I have tried to remove these duplications using a tuple query but I am still curious to solve my earlier problem
 
You know it is dark times when the trees riot. I think this tiny ad is their leader:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic