Joining MS SQL tables in a JDBC query

Question

I'm using a JDBC query to an MS SQL database as a datasource for a view. The datasource is something like:

<xp:this.data>
    <xe:jdbcQuery connectionName="mssql" sqlQuery="select * from table" var="jdbcData1">
    </xe:jdbcQuery>
</xp:this.data>

I can add parameters to this (eg: where col=?) and it all works fine, but I can't manage to get a join working. Is it possible to join two tables in this manner?

Can you post the SQL statement with the join that you are attempting? — Jeff Byrd, May 07 '13 at 15:03
I've tried a few: as simple as `select * from table1 join table2` or adding conditions/parameters `select * from table1 join table2 on table1.col = table2.col where param=?`, none have worked. — Josh Jolly, May 07 '13 at 15:47

score 0 · Answer 1 · answered May 12 '13 at 13:41

0

Yes this should work without any problems as its just crating the Statement to run against the JDBC Server.

answered May 12 '13 at 13:41

Toby Samples

2,168
14
15

Joining MS SQL tables in a JDBC query

1 Answers1