_id
-> group by invoices.job_id
thanks again!! -- K:)
on 28/8/02 11:47 Uhr, Amer Neely at [EMAIL PROTECTED] wrote:
>> Subject: job database with invoicing
>> Date: Tue, 27 Aug 2002 22:05:43 +0200
>> From: Kai Vermehr <[EMAIL PROTECTED]>
>> To: MySQ
>Subject: job database with invoicing
> Date: Tue, 27 Aug 2002 22:05:43 +0200
> From: Kai Vermehr <[EMAIL PROTECTED]>
> To: MySQL List <[EMAIL PROTECTED]>
>
> I'm building a job database with simple invoicing. I have one table called
> JOBS and one
I'm building a job database with simple invoicing. I have one table called
JOBS and one called INVOICES. In INVOICES there's a foreign key column
called job_id referencing INVOICES to JOBS.job_id.
in a simplified way it looks like this:
(there are a lot of other columns of course)
tabl
