AnsweredAssumed Answered

What should I do if the match involves both parent and child fields?

Question asked by SimonLiu on May 29, 2011
Latest reply on May 31, 2011 by philmodjunk

Title

What should I do if the match involves both parent and child fields?

Post

I have 2 tables with fields respectively.

Table {Customer} with:

 <pk_CustomerID>: Serial

<Status>: Text, "Active"/"Inactive"

Table {Invoice} with:

<fk_CustomerID>

<Shipment>: Text, "Shipped"/"Not Shipped"

<Amount>: Number

Tables are related:Customer::pk_CustomerID = Invoice:: fk_CustomerID


How can I get a total amount of the invoices whose Customer status is "Active" and the invoice shipment status is "Shipped"?

Screen_shot_2011-05-30_at_12.23.02_AM.png

Outcomes