Skip to Content
0
Former Member
Dec 03, 2008 at 06:47 PM

Help in editing the query

16 Views

Dear all,

we wrote one query to fetch wrong entries as per the clients requirement. Here is our query

SELECT A.TRANSID, A.VATAMOUNT, A.VATGROUP, B.BASEREF,

C.CARDCODE, D.DEBPAYACCT, E.SEGMENT_3,B.REFDATE

FROM JDT1 A JOIN OJDT B

ON A.TRANSID=B.TRANSID

LEFT OUTER JOIN OINV C

ON B.BASEREF=C.DOCNUM

LEFT OUTER JOIN OCRD D

ON C.CARDCODE=D.CARDCODE

LEFT OUTER JOIN OACT E

ON D.DEBPAYACCT=E.ACCTCODE

LEFT OUTER JOIN OCRD F

ON C.CARDCODE=F.CARDCODE

right OUTER JOIN OASC G

ON G.CODE=E.SEGMENT_3

SELECT * FROM DBO.V_GET_GLST_INFO

WHERE CONVERT(VARCHAR, REFDATE,112) BETWEEN '20080701' AND '20081231'

AND VATGROUP='S1-Lb' AND SEGMENT_3 = '11'

in this query i have to give segment as parameter so when i tries to execute this query it does not fetch the data. please can anybody will help me.

thanks & Regards

Tavargeri Ganesh