From: "Heald, Tim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 3:47 PM
Subject: RE: Billing System Query Help
> Do you have link (foreign key) columns?
>
> With what you have here I am not sure how you would write a join.
>
> Also what db? It matters :)
>
Doh... yeah, I guess I forgot something. :) It's MySQL 3.
Invoices
-----------------------------
InvoiceID PK INT
CustomerName VARCHAR
InvoiceItems
-----------------------------
InvoiceItemID PK INT
InvoiceID FK INT
ItemAmount CURRENCY
InvoicePayments
-----------------------------
InvoicePaymentID PK INT
InvoiceID FK INT
PaymentAmount CURRENCY
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
