I need to inner join 2 tables using JDBC.I am using SQL Server database and my tablenames are BS_1137_2_8 and ReservedInventory and I am using following code:

String str="select top 1 t1.ticketinfo , t1.seat from BS_1137_1_28 t1";

str+="inner join ReservedInventory RI1 on t1.ticketinfo=RI1.id and " + "RI1.status=-1";

ResultSet rs=stmt.executeQuery(str);

When I run the program then it gives error saying that colum prefix t1 does not match with a table name or alias name used in the query.Though I have given alias t1 to table BS_1137_2_8 and when I execute only this part "select top 1 t1.ticketinfo , t1.seat from BS_1137_1_28" then it successfully executes.I am not sure if concatenation is done correctly or not.Can anybody help me??

It appears you just need an extra space before the keyword "inner", otherwise it is getting appended right onto the table name?

FileMaker Version: Dev 7

Platform: Mac OS X Panther

Join syntaxe doesn't work with Fmp and JDBC

You need to create a portal on your layout and use an array to retreive related records.

Hi,

FileMaker Pro supports Join statement. It appears that the space before inner keyword should solve the problem. If not, then keep all the query statements after "On" in braces.

--Sanjai