Hi,
I'm newbie on WebObjects and I have big problem to fetching on joined table.
Example :
I have my SQL like that :
select
a.id b.id as ID,
c.option as option,
decode(d.no, 1, 'one', 2, 'two', 'unknow') as order
from
ta a, tb b, tc c, td d
where
c.option in ('1', '2','3')
and c.option = b.option
How to translate this SQL request in EOF using qualifier or spec qualifier?
Thanks for your help.
Ray
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
