This may have been answered elsewhere but I am unable to locate it:
I am in need of an example for a join query. Here is the situation... two
tables that look like this....
CREATE TABLE one (
keyid int not null,
blah1 char(10),
blah2 char(10),
blah3 char(10)
) PK = keyid;
CREATE TABLE two (
fkid int not null,
key1 int not null,
key2 int not null
) PK = fkid, key1, key2, FK = fkid -> one(keyid)
I am trying to get the collection of table one Objects for a given table
two(key1, key2) combination. I think I have the XML descriptors set up right
but am not sure. I have searched the website for an exmaple of java code
with the XML descriptor that I can model after - but have as yet been unable
to find one. Can anyone help with a small snip of what this looks like? Or
maybe its in a page I just have not read yet and you can forward me to the
URL?
Thanks,
Joe Campbell
--
You laugh at me because I am different,
I laugh at you because you are the same.
-----------------------------------------------------
Joseph Campbell | EMAIL: [EMAIL PROTECTED]
Staff Consultant | URL: www.inventa.com
Inventa Technologies | PH: (856)914-5200
| PGER: (888)454-0876
-----------------------------------------------------
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
