Skip to Content
0
Mar 03, 2011 at 04:18 AM

Query Check

15 Views

Hi Experts,

SELECT T0.NUMATCARD, T0.[DocDate], T0.[CardName],T0.[Address], T3.[TaxId0], T0.[DocTotal] FROM OPCH T0 INNER JOIN CRD7 T3 ON T0.CARDCODE = T3.CARDCODE WHERE T0.DOCTOTAL > [%0] AND T0.CARDNAME = [%1]

Above given query runs every record two time.

i.e.

DocNum, DocDate, CardName, Address, TaxId0

1, 12-02-11, ABC , Surat, India, ABCDE12345

1, 12-02-11, ABC , Surat, India, ABCDE12345

plz help.

Regards,

Ravi

Edited by: RAVI_JHA_SAP on Mar 3, 2011 5:19 AM