Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Parent child join query

 
Raaj Aaryan
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • 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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic