If it support "compounde query"

[2002 JI Open Discussion]

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.

Susan

 

 

 

 

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'.

 

Ryan

 

 

 

 

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.

 

Thanks

 

 

 

 

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.