how to generate multiple aliases in a SELECT
how to generate multiple aliases in a SELECT
- Subject: how to generate multiple aliases in a SELECT
- From: "Alex Blaj" <email@hidden>
- Date: Wed, 20 Aug 2003 10:54:29 +0300
Hi there,
I need to create a fetchSpecification that would generate a SELECT statement
like this:
"SELECT T1.PK FROM TABLE1 T1, TABLE2 T2, TABLE2 T3 WHERE
T1.PK = T2.TABLE1_ID AND T2.PK = 1 AND
T1.PK = T3.TABLE1_ID AND T3.PK = 2;"
The difficult thing is to create 2 qualifiers for this fetchSpecification that
would generate the "FROM TABLE2 T2, TABLE2 T3" (2 aliases for the same table
TABLE2).
Everything I tried so far led me to a single alias to TABLE2 in the FROM
part.
Or, if there is anyone specialized in FrontBase (or some other database
support which supports "(SELECT ... ) INTERSECT (SELECT ...);"), could you
tell me how to implement the INTERSECT into my fetchSpecifiction?
I'm using WO 5.2 with FrontBase.
Any hint would be highly appreciated.
Alex.
===================================================================Lettrix bv,
P.O. Box 5, 6980 AA Doesburg,
The Netherlands -- Tel: +31 313 478 000,
Fax: +31 313 478 080 -- Check our website at:
http://www.lettrix.com
===================================================================Disclaimer
:
The information contained in this communication is confidential and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking any
action in reliance on the contents of this information is strictly
prohibited and may be unlawful. Lettrix B.V. is neither liable for
the proper and complete transmission of the information contained in
this communication nor for any delay in its receipt.
_______________________________________________
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.