SQL Query

Views (59)

I AM AX PANKAJ

419

Like(0)

Report

select * from purchline Inner Join
VENDPACKINGSLIPTRANS On VENDPACKINGSLIPTRANS.ORIGPURCHID=PurchLine.[PURCHID] and VENDPACKINGSLIPTRANS.PURCHASELINELINENUMBER=PURCHLINE.[LINENUMBER]
Where PurchLine.[PURCHID]='5030808' and PurchLine.ITEMID Like'69J-45300-23-8D'

Select * from VENDPACKINGSLIPTRANS where [ORIGPURCHID] In ('5030360','5030554','5030586','5030607','5030656','5030719','5030756','5030778','5030807','5030808','5030809','5030816','5030826','5030836','5030845','5030852','5030855','5030864','5030882','5030890','5030897','5030901','5030910','5030915','5030917','5030920','5030927','5030934','5030947','5030954','5030957','5030965','5030972','5030976','5030980','5030984','5030987','5030990','5030994','5031002','5031006','5031016','5031021','5031025','5031029','5031031','5031034','5031039','5031043','5031047','5031053','5031056','5031060','5031064','63836','63839','63899')