MQSeries.net :: View topic - ESQL SELECT question

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » ESQL SELECT question

ESQL SELECT question

« View previous topic :: View next topic »

Author

Message

Bosco

Posted: Tue Dec 02, 2003 4:47 pm Post subject: ESQL SELECT question

Novice

Joined: 30 Nov 2003
Posts: 17

I want to join 2 tables in the following ESQL SELECT statement but I keep getting error when executing the msgflow on the tables join. Can anyone help?!! Thanks

SET OutputRoot.XML.Message.MessageFlowName[] =
(SELECT B.CNAME, E.CNAME, E.CLASTUPDATE
FROM Database.MQMBUSER.CBROKER AS B, Database.MQMBUSER.CMSGFLOW AS E WHERE E.CSECTION = 'DEPLED' AND E.CBROKERCUUID = B.CUUID);

jefflowrey

Posted: Wed Dec 03, 2003 5:37 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You'll probably get a better answer if you ask this question in the WMQI forum.

And you'll certainly get a better answer if you post more details about the error you are getting.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » General Discussion » ESQL SELECT question

Jump to:

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

Protected by Anti-Spam ACP