I have two tables invoice and payments
invoice has following columns :
Jan , 10001, X,3,10.00
Payment table :
Need help to show the below data using a query :
Jan , 10001 ,X, 3, 10.00 , 10.00 ,Jan
Jan , 10001, Y, 5, 20.00, 20.00,Jan
Jan , 10001, A,1, 5.00, 5.00,Jan
Feb ,10001, A, 1, 5.00, 5.00,Mar
This is similar to cr/db posting in banking ...
Any thoughts ?
I'm wondering what the problem is... have you even give it a try?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width