fetching on joined table
fetching on joined table
- Subject: fetching on joined table
- From: email@hidden
- Date: Sat, 09 Apr 2011 02:16:19 +0200 (CEST)
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden