cancel
Showing results for 
Search instead for 
Did you mean: 

This query is not executing in Query Generator

former_member815525
Discoverer
0 Kudos
110

Select distinct T0.[CardCode], T0.[CardName], T1.[Project], T0.[DocNum], T0.[DocDate],T4.[DocNum],

T4.[DocDate],T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T3.[BatchNum], T3.[Quantity],

T1.[UseBaseUn], T2.[ExpDate], T2.[PrdDate]

FROM OPDN T0

INNER JOIN PDN1 T1 ON T0.[DocEntry] = T1.[DocEntry], OIBT T2 INNER JOIN IBT1 T3 ON T2.[ItemCode] = T3.[BatchNum], OPOR T4

where T0.docentry=5729

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Is there any error because it runs fine on query generator in demo?

Accepted Solutions (0)

Answers (1)

Answers (1)

LoHa
Active Contributor

Hi Amit

there is no join between OPDN and OIBT

FROM OPDN T0

INNER JOIN PDN1 T1 ON T0.[DocEntry] = T1.[DocEntry], OIBT T2 INNER JOIN IBT1 T3 ON T2.[ItemCode] = T3.[BatchNum], OPOR T4

regards Lothar