Xhello people, i dev a sql string for each table in array of 10 tables, for each table i need filter to article and operation, i do this job with inner join for each table (article, operation), but the results are ok only in case dont exist 2 records equal, in this case only i obtain 1 record, how i can obtain all records with the conditions ok?, this is my code:

SELECT DATA06.TRANS_NRO,DATA06.PROVIDERID,DATA06.OPERATION,DATA06.ARTICLE,DATA06.DATE,DATA06.und_i,DATA06.und_s,ocOperaciones.orden as [orden] FROM D:\DATA\DATA06.DBF right join OcOperaciones ON DATA06.OPERATION=ocoperaciones.cid WHERE seek(DATA06.ARTICLE,[ocARTICLE],1) AND DATE>={^2000/06/01} AND DATE<={^2000/10/01} UNION SELECT DATA07.TRANS_NRO,DATA07.PROVIDERID,DATA07.OPERATION,DATA07.ARTICLE,DATA07.DATE,DATA07.und_i,DATA07.und_s,ocOperaciones.orden as [orden] FROM D:\DATA\DATA07.DBF right join OcOperaciones ON DATA07.OPERATION=ocoperaciones.cid WHERE seek(DATA07.ARTICLE,[ocARTICLE],1) AND DATE>={^2000/06/01} AND DATE<={^2000/10/01} UNION SELECT DATA08.TRANS_NRO,DATA08.PROVIDERID,DATA08.OPERATION,DATA08.ARTICLE,DATA08.DATE,DATA08.und_i,DATA08.und_s,ocOperaciones.orden as [orden] FROM D:\DATA\DATA08.DBF right join OcOperaciones ON DATA08.OPERATION=ocoperaciones.cid WHERE seek(DATA08.ARTICLE,[ocARTICLE],1) AND DATE>={^2000/06/01} AND DATE<={^2000/10/01} UNION SELECT DATA09.TRANS_NRO,DATA09.PROVIDERID,DATA09.OPERATION,DATA09.ARTICLE,DATA09.DATE,DATA09.und_i,DATA09.und_s,ocOperaciones.orden as [orden] FROM D:\DATA\DATA09.DBF right join OcOperaciones ON DATA09.OPERATION=ocoperaciones.cid WHERE seek(DATA09.ARTICLE,[ocARTICLE],1) AND DATE>={^2000/06/01} AND DATE<={^2000/10/01} UNION SELECT DATA10.TRANS_NRO,DATA10.PROVIDERID,DATA10.OPERATION,DATA10.ARTICLE,DATA10.DATE,DATA10.und_i,DATA10.und_s,ocOperaciones.orden as [orden] FROM D:\DATA\DATA10.DBF right join OcOperaciones ON DATA10.OPERATION=ocoperaciones.cid WHERE seek(DATA10.ARTICLE,[ocARTICLE],1) AND DATE>={^2000/06/01} AND DATE<={^2000/10/01}INTO CURSOR _0J00QP1JU ORDER BY 3,7


is that correct? i need something more?

with Best Regards


Francisco Morosini