inner join query help
inner join query help
- Subject: inner join query help
- From: Theodore Petrosky <email@hidden>
- Date: Sat, 5 Feb 2011 04:07:40 -0800 (PST)
I could fairly easily do this in SQL with a join but i am lost in WO.
I have two entities Version Invoice
my full schema looks like:
ParentCompany toMany
Client toMany
Project toMany
Job toMany
Version toOne
Invoice
The Version may have many invoices because the version may be partially billed.
in my Invoice report, I will see:
Version 1 partial 01-01-2011
Version 1 final 01-30-2011
Version 3 final 01-05-2011
So what happened to version 2. The version was killed in production. there will be no version 2 invoice. (Let's also add that there could be a version 2.1 or even 2.1 subversion 1 and any of these could be killed.)
Invoice only records the versions that are invoiced. so indeed there could be versions not included in the invoice list.
Normally I would join the invoice list against the version list. Then I would have a complete list of invoices and versions. There would be no 'holes' where a version was killed.
Version 1 partial 01-01-2011
Version 1 final 01-30-2011
Version 2 killed
Version 2.1 final 01-30-2011
Version 3 final 01-05-2011
How to do this the WO way?
I hope I am clear.
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden