Hi- When I try to use a standard sql query SELECT FROM WHERE in my jsp code, I can pull data, but when I try to use a join in my code, there is a problem. I've used both the ansi join and the MS join in my code. My code has looked something like this...
SELECT Table1.Field1 FROM Table1 JOIN Table2 ON Table1.Field2=Table2.Field1 WHERE Table2.Field2 = '" + variable + "'
or
SELECT Table1.Field1 FROM Table1 , Table2 WHERE Table1.Field2=Table2.Field1 AND Table2.Field2 = '" + variable + "'
So I think it might be a problem with my Access DB relationships. I have the fields indexed and I have the tables linked and have tried the different relationship options. Does anyone have any suggestions?
Thanks!!
SELECT Table1.Field1 FROM Table1 JOIN Table2 ON Table1.Field2=Table2.Field1 WHERE Table2.Field2 = '" + variable + "'
or
SELECT Table1.Field1 FROM Table1 , Table2 WHERE Table1.Field2=Table2.Field1 AND Table2.Field2 = '" + variable + "'
So I think it might be a problem with my Access DB relationships. I have the fields indexed and I have the tables linked and have tried the different relationship options. Does anyone have any suggestions?
Thanks!!