Two tables walk into an EO model...
Two tables walk into an EO model...
- Subject: Two tables walk into an EO model...
- From: Goodbye Bill <email@hidden>
- Date: Sun, 03 Aug 2003 05:31:54 -0400
Okay, last attempt. I THINK I can explain this so that someone can answer
it.... at least, I hope I can...
I have two tables in a many-to-many relationship. I need to be able to use
a qualifier from ONE table and another qualifier for the OTHER table. I
need to return all of those that remain.
Example...
ENTITY #1: Employee
idEmployee
nameFirst
nameLast
gender
ENTITY #2: Office
idOffice
name
postalCode
Again, any amount of employees can be associated to any amount of offices,
so there IS a many-to-many relationship.
Using this example above, I need to find all Employees based on the
following criteria:
1. Employee must be female; and
2. Office must be located in the 06492 postal code
How in the world does one do this?
Thanx,
"Bill"
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.