getting the results of a sub select
getting the results of a sub select
- Subject: getting the results of a sub select
- From: Theodore Petrosky <email@hidden>
- Date: Tue, 15 Mar 2005 04:45:08 -0800 (PST)
- Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
I am rather new to this so please be gentle....
I finally have an interface with webobjects talking to
my postgresql db. I am having a problem with a sub
select.. in schema, i have a job table and a client
table. the job table of course has a primary key of
the jobnumber. the client table has a PK of the
clientcode. each job row is assigned to a clientcode.
in cocoa I can do...
select jobnumber, (select cname from clientinfo ci
where ci.ccode = j.acode) as clientname, shortdesc
from jobinfo j order by jobnumber;
works great...
I am using the marker book and a few others and I just
can not seem to grasp how to populate my table in
webobjects. It appears to be a WOtoOneRelationship (I
think).
the end result should be:
jobnumber clientname shortdesc
of course I can easily get
jobnumber clientcode shortdesc
could someone point me in the right direction.....
thanks,
Ted
__________________________________
Do you Yahoo!?
Yahoo! Sports - Sign up for Fantasy Baseball.
http://baseball.fantasysports.yahoo.com/
_______________________________________________
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