| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL-Outer join |
« View previous topic :: View next topic » |
| Author |
Message
|
| gobi_nathan |
 Posted: Wed Nov 12, 2003 4:58 am Post subject: ESQL-Outer join |
 |
|
Acolyte
Joined: 08 Jan 2003
Posts: 69
|
Hi All,
Is it possible to use the outer join (similar to oracle) in ESQL.If anyone used please tell me how to bring the same functionality using ESQL?
Regards,
Gobi. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Nov 12, 2003 7:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can certainly do a join.
| Code: |
| SELECT T.field1, R.field2 from Database.TABLE1 as T, Database.TABLE2 where T.dataID = R.dataID |
But I don't remember if it's an inner or outer join. The ESQL Reference guide has a whole chapter on using the SELECT statement.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Nov 12, 2003 1:55 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If I am not wrong, this is an example of inner join. I don't think you can do an outer join directly in ESQL. You may use PASSTHRU function to do an outer join in your message flow.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
