Hello I have used a similar SQL in a jasperreport:"select invoice.invoiceNo, fromWh.WhName as fromWhName, toWh.WhName as toWhName from invoice inner join IcWh as fromWh on (invoice.whId=fromWh.WhId) inner join IcWh as toWh on (invoice.Whid=toWh.WhId)"
The report is running fine while I run it from iReport but it does not find the column fromWhName or toWhName while I run the report from java program. Can you help to resolve this issue? Thanks in advance. Regards, Mortoza __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
