Has anybody successfully used a JOIN?

[sween]

I have a ticket into JIRA regarding this and another post, but thought I would troll the forum to see if anybody has successfully used a JOIN (in any db) for the Database Reader SQL Statement? If you have can you share the syntax and DB you are using ?

I have failed to get it to work on two different platforms: postgres / mysql on winders and mac...

JIRA Issue


My join is pretty straightforward... and works from the shell...

THANKS, IM STUCK

[chrisl]

Re: Has anybody successfully used a JOIN?

Sween -

It doesn't appear that Mule (our ESB) supports JOINS - however there is a way to access the native Java JDBC layer from the transformer (using the createDatabaseConnection function that you can drag and drop).

Check the forum for a few examples of using this, or shoot me an email for an example channel.

-Chris