Last post Jan 27, 2016 07:36 AM by Weibo Zhang
Jan 04, 2016 02:07 PM|asp.net4|LINK
Hi i have the following tow tables
i need to get statement for certain customer where each receipt voucher must be under invoice so i avoid getting negative values
the out put supposed to be like this
your help is much appreciated
Jan 04, 2016 03:30 PM|chilluk|LINK
What links the voucher to the invoice?
Jan 27, 2016 07:36 AM|Weibo Zhang|LINK
Could you show a clear image to show the table structures so that we could better help you? Then, you’d clarify each column in the result comes from which table.
Besides, you could refer to the following links to learn the T-SQL join query and then try to do it by yourself at first.