Hello,
I work with PeopleSoft Financial queries. I am trying to create a query from two different tables:
Table:A Error Voucher # Count
Table B: Total Voucher # Count
If I join on A. Voucher ID= B. Voucher ID this will only give me voucher number that are equal
I would also add the criteria A. enterdate = b. enterdate so that I can pull the number of voucher from each table for the same time period.
My query should give me the following results
Date Total Number of Vouchers entered Voucher Errors
8/10/07 100 60
My only options are a regular join or a left join.
Hopefully this is in the right zone, if not, could you please let me know where I should place this question.
Thanks much.
Start Free Trial
