I am trying to make a query on Crystal report, I have added two tables
I am trying to perform a left join but i just don't know how to do this within crystal
in design i have built this
SELECT
ARTCR."IDRMIT", ARTCR."IDCUST", ARTCR."DATERMIT", ARTCR."AMTRMIT", ARTCR."TEXTPAYOR",
ARTCRO."VALUE"
FROM
{ oj "Sample"."dbo"."ARTCR" ARTCR INNER JOIN "Sample"."dbo"."ARTCRO" ARTCRO ON
ARTCR."CNTBTCH" = ARTCRO."CNTBTCH"}
WHERE
ARTCRO."VALUE" >= 'Cob0006'
ORDER BY
ARTCRO."VALUE" ASC,
ARTCR."DATERMIT" ASC,
ARTCR."IDCUST" ASC,
ARTCR."IDRMIT" ASCThere are 4 parameters fromdate todate fromloc toloc
here is the selection criteria
{@dFecha}>={?FROMDATE} and
{@dFecha}<={?TODATE} and
{ARTCRO.VALUE}>={?FROMLOC} AND {ARTCRO.VALUE}>={?TOLOC}but if i run it like this, i have duplicated result set, so i need to modify the query to be a left join
how do i do that?
.......
DO WHILE .T.
ME.Work()
ENDDO
