Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
You probably have the wrong join to DETAILNUM
*note: Filter COINTYPE = 1 to include comments and not instructions
SQL:
SELECT dbo.OEINVH.INVNUMBER, dbo.OEINVD.ITEM, dbo.OEINVD.MISCCHARGE, dbo.OECOINI.COINTYPE, dbo.OECOINI.UNIQUIFIER, dbo.OECOINI.COIN
FROM dbo.OEINVH INNER JOIN
dbo.OEINVD ON dbo.OEINVH.INVUNIQ = dbo.OEINVD.INVUNIQ LEFT OUTER JOIN
dbo.OECOINI ON dbo.OEINVD.INVUNIQ = dbo.OECOINI.INVUNIQ AND dbo.OEINVD.DETAILNUM = dbo.OECOINI.DETAILNUM
WHERE (dbo.OECOINI.COINTYPE = 1)
Jay
thanks for the help. I missed that link.
You are the best!
Hi chiman, if the above suggested answer helped, please do mark it as verified for the benefit of others in this forum :). Thank you!
If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey
*Community Hub is the new name for Sage City