Jump to content
Changes to the Jaspersoft community edition download ×

If it support "compounde query"

Recommended Posts

By: susun - wellrun

If it support "compounde query"

2003-07-18 02:31

I want retrieve data from 2 tables and define a <queryString> like "select table1.nam ,table2.pam from table1,table2 where table1.key=table2.key order by key". It seems like it does not support this type and cannot resolve the fileds i have defined.

I want to know how to do this.


Thank you.






By: Ryan Johnson - delscovich

RE: If it support "compounde query"

2003-07-18 08:59

The sql is invalid - you have an ambiguous field 'key' in the order by clause. Try ordering by 'table1.key'.







By: susun - wellrun

RE: If it support "compounde query"

2003-07-20 18:22

Thanks for your Reply

Then you mean it support the compound query,then how i define the filed name in the report? It named "table1.nam" ? But it has the exception means it cant find this filed.







By: thomas - ddw1101

RE: If it support "compounde query"

2003-07-21 04:23

it support the compond query:order by table1.key

you can name "nam" of table1 for the field.

or name "column_num".

otherside, you can use subreport to do it , it is difficult to realize.

thirdly, you can program 2 table into a table.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...