i have scenario in which i will have to do a left outer join with the table itself, for Example SQL Query:
                     Select ( str(p.questionNumber)+str(q.QuestionNumber) ) as sortOrder from Questions q left outer join Questions p on q.parentQuestionID = p.QuestionID order by sortOrder
               i have done it in Crystal report using alias in Data Expert for Question table.When i see the preview in Crystal report i am able to see the Questions from the questions table in  sorted order.But while using the same rpt file from the jave application i am not able to see the questions. i am not able to figure out the reason why it is happening???.
P.S: ParentQuestionID Column in Question Table has NULL values also.Is there any property that i have set for this??