I'm working on some code to pull a list of orders containing a particular performance and using a particular payment method. The problem I'm running into is that T_PAYMENT and T_TRANSACTION don't seem to contain payments made for orders that don't have customer numbers attached. And in this instance, all of the orders I'm looking to isolate do not have a customer attached. Is there any other table that contains ALL payments/transactions, so I can edit my joins accordingly? I'm coming up blank when I look around for one.
Hi Alicia
T_PAYMENT and T_TRANSACTION have all the payments in them, unless there's something very wrong with your system.
But all Orders have a customer number on them - if the sale is to the general public, rather than a specific customer, it should have customer_no = 0. That can trip up joins sometimes, if you're not careful.
...If you post your code here, someone on the forums will probably spot the problem....
Ken