Hello, everyone, I know you are all busy I have I think is a little complicated question but maybe somebody has done something like this before. What I want to do is in Java query a table that some information. Which is fine however. I want to output this to a file in a certain format that is requested. The problem I am having one of the key fields is not always the same and the other key field which is based on the first key field is not always the same either. I know this probably isn't making much sens but let me give you an example.
Let say I have a column that has the number 4 in for about 20 rows and then accross that is another column that may have 4 in it or also 3. Now there is more info in the row so what I want to do in java is select "" info that is related to number 4 and other coulumn 4 and output in a format. with out repeating the number 4 20 times. Then I need to output the info that is still related to the first coulmn 4 but now is related to the 3 instead of the for. So in other words I don't want to just read eact record and output it into the file. I need to to do it by bassing the relation ship on the coulumn that has 4 in it and the second coulmn that has 4 and 3. In other words I don't want reduntant coulmn 1 and 2 being repeating data. If anyone can help I will most happly hook you up with some points. Thanks for anyone that is willing to help.