SQL join problem

[chrisssteeven]

Hi,
I am using the following query with a zip bind variable.
from Store _a join Pricing _b on _a.storeid=_b.storeid where _a.zip=:zip
I get the following error:Run Query error: Unexpected Token: on near line 1 column 59 [from com.wavemaker.gasprice.data.Store _a join Pricing _b on _a.storeid=_b.storeid where _a.zip=:zip].According to HSQL syntax, this join should work perfectly.What am I doing wrong?

[Steve Lewin]

Posting your query in the wrong forum ?

This FMS is a "Flying Model Simulator" as it says at the top of every page. I have a feeling you might be looking for a different FMS .

Steve