Skip to Content
0
Former Member
Nov 09, 2012 at 03:17 AM

correct this query

35 Views

hi

while run this query it is showing no data's found

SELECT T1.[ItemCode], T1.[Dscription], T1.[Quantity], T0.[BatchNum], T0.[Located] FROM OIBT T0 inner join IGE1 T1 on T0.[ItemCode] = T1.[ItemCode] WHERE T0.[BaseType] = '60' and T1.[BaseRef]=[%0] GROUP BY T1.[ItemCode], T1.[Dscription], T1.[Quantity], T0.[BatchNum], T0.[Located]