Boris
2-Jun-2010, 11:18 AM
I have a table (ICPROD), related with ICMARCA and ICGRUPO as shown in the image (vrw4.png). When I try to run the report I get an error (vrw5.png) saying that I specified the link to ICMARCA more than once.
When I click on the Show SQL Query, I get this:
SELECT "ICPROD"."CODIGOMARCA", "ICPROD"."PRODNUMERO", "ICPROD"."PRODNOMBRE", "ICPROD"."CIA", "ICMARCA"."NOMBREMARCA" FROM ("dbo"."ICPROD" "ICPROD" LEFT OUTER JOIN "dbo"."ICMARCA" "ICMARCA" ON "ICPROD"."CIA" = "ICMARCA"."CIA") INNER JOIN "dbo"."ICMARCA" "ICMARCA" ON "ICPROD"."CODIGOMARCA" = "ICMARCA"."CODIGOMARCA" WHERE "ICPROD"."CIA"='40' ORDER BY "ICPROD"."CODIGOMARCA"
When I click on the Show SQL Query, I get this:
SELECT "ICPROD"."CODIGOMARCA", "ICPROD"."PRODNUMERO", "ICPROD"."PRODNOMBRE", "ICPROD"."CIA", "ICMARCA"."NOMBREMARCA" FROM ("dbo"."ICPROD" "ICPROD" LEFT OUTER JOIN "dbo"."ICMARCA" "ICMARCA" ON "ICPROD"."CIA" = "ICMARCA"."CIA") INNER JOIN "dbo"."ICMARCA" "ICMARCA" ON "ICPROD"."CODIGOMARCA" = "ICMARCA"."CODIGOMARCA" WHERE "ICPROD"."CIA"='40' ORDER BY "ICPROD"."CODIGOMARCA"