| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| LEFT JOIN in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| nu1 |
 Posted: Wed Jan 28, 2004 3:14 pm Post subject: LEFT JOIN in ESQL |
 |
|
Apprentice
Joined: 28 Nov 2003
Posts: 26
|
Hi
How can I implement LEFT JOIN in ESQL
FOr example if the SQL is
SELECT A.field1, A.field2, B.field3, B.field4, C.field5 FROM Table2 B, Table1 A LEFT JOIN Table3 C ON A.field1 = C.field5 WHERE A.field1=B.field3 AND A.field1=123;
If I execute this ESQL code the query fails for certian values
SELECT T.field1,T.field2,S.field3,S.field4,R.field5 FROM Database.Table2 AS B, Database.Table1 AS A, Database.Table3 AS C WHERE
T.field1=T.field3 AND T.field1=123 AND T.field1=R.field5
Can sombody let me know a smart way to deal this JOIN statement in ESQL.
Thanks
_________________
-nu1 |
|
| Back to top |
|
 |
| CoolDude |
| Posted: Wed Jan 28, 2004 3:38 pm Post subject: |
|
|
Apprentice
Joined: 17 Jan 2004
Posts: 39
|
not all database operations can be implemented using ESQL. check the ESQL reference manual if JOIN operations are supported.
you can use the PASSTHRU statement to achieve the same using PASSTHRU.
_________________
Correct Me from Wrong  . If i am correct Appreciate Me  |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Jan 28, 2004 8:28 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
|
| Back to top |
|
|
| mgk |
| Posted: Thu Jan 29, 2004 2:27 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi, we only support inner joins in esql. As suggested, you can use passthru to execute a left join
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| nu1 |
| Posted: Thu Jan 29, 2004 7:32 am Post subject: |
|
|
Apprentice
Joined: 28 Nov 2003
Posts: 26
|
thanks for your response..
I used passthru and I am able to implement leftjoin in ESQL.
thank you
_________________
-nu1 |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
