i have a table Account Master and second table Transaction with column ID,Date,CreditID,DebitID,Note,CreditAMT,DebitAMT,CreditBalance, DebitBalance.
i have two slices from this table ,one with ID,CreditID,CreditAMT,DebitAMT, CreditBalance, other with ID,DebitID, CreditAMT,DebitAMT,DebitBalance. i want to combine these two slices and want to get data as single table for AccountID for ledger record. how can this possible ?
Nope, you canโt.
@Steve can you please re-tag this post as Question at your convenience? Thnx.
The only way to accomplish something like this would be to create a third table, which contained matching columns between the other two tables, and then populate that third table with your combined records.
Itโs a duplication of data, not really something that should be done as standard procedure, but it would accomplish what youโre looking for.
@deepak_patel have you checked out references? You can connect your transactions table to the account table using a reference, then youโll see a list of all related transactions per account.
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
20 |