inner join

[2002 JI Open Discussion]

By: Parinit G - paribest

inner join

2003-06-20 09:26

hi,

i am trying a simple inner join sql statement in my report. but i am getting a empty report.

 

my sql in query string:

 

select proj.project_id, proj.proj_title, app.app_name

from project proj, application app.

 

in report:

i use:

 

<field name="project_id" class="java.lang.String"/>

 

 

<textFieldExpression class="java.lang.String">$F{project_id}</textFieldExpression>

 

AM I DOING ANYTHING WRONG. PLEASE ADVICE.

 

THANK YOU FOR YOUR HELP.

 

..PARI

 

 

 

 

 

By: Parinit G - paribest

RE: inner join

2003-06-20 09:29

please ignore this post. i was not using the connection pool giving me a blank report