Customer/Modifier relationships

Hi,

Using ESB tables, I'm trying to create SQL that will return the customer number, customer name, ship-to address, sales territory, invoice number, invoice date, invoice balance in USD currency, and the modifier name and modifier extended amount for all modifier lines present on the invoice (if any) for all invoices which have a current balance.

Is this correct?

1.  A customer can have zero to many invoices.
2.  A invoice can have one to many items.
3.   A item can have one to many prices.   This may be optional, i.e. we cna jump from invoice to modifiers.

4.  A price can have zero to many modifiers.