I am trying to write a query using SQ01/SQ01. I am trying to access an additional table in the coding section. I have added the table declaration in the code and the code to populate the field. When I generate the infoset it checks error free. I then write the query against the infoset and I get a table already declared error during compilation of the query for my additional table. This table is not part of the join.
If I remove the additonal table from the code and generate the infoset and query then look at the code generated I see the table I am trying to add in the tables declaration in the generated code.
The conflict will not let me report on this table in the query. Anyone have any experience overcoming this problem?