Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- C.NAME,
- S.GOODUC,
- SG.SERIES,
- S.BASETOTAL,
- S.TOTAL,
- S.DELTA,
- S.RPRICE
- FROM
- SDOC0182 S,
- GOODS C,
- SERIESGUIDE SG
- WHERE
- (C.UNIQUECODE = S.GOODUC) AND
- (SG.ID = S.SGID) AND
- (S.DOCUMENTID = (SELECT MAX(D.DOCUMENTID) FROM DOC0182 D WHERE (D.ISCLOSED = 0) AND (D.STATE = 8) AND (D.DOCUMENTTYPE = 60) PLAN JOIN (D INDEX (DOC0182_ISCLOSED)) ) ) AND
- (S.INVOICEID = -20962) AND (S.INVOICEITEM = 46)
- PLAN JOIN
- (S INDEX (SDOC0182_PRIM), C INDEX (GOODS_UC), SG INDEX (SERIESGUIDE_ID))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement