on 2008 Jul 28 6:23 AM
一张表为余额表,一张表为明细发生表。
如果做一张报表时,余额在表头出现,明细在中间出现,按照期间作为选择条件。如果当期没有发生额,现在的状态是:没有此张报表出现。
目标:显示此张报表,期初为年初数加上此期间以前的余额,发生额为0,或者空,期末余额等于起初余额。
请问哪位高手可以帮忙一下啊!!
Request clarification before answering.
left join
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
分清主从关系 使用外连接
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
4 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.