SQL join problem

chrisssteeven
chrisssteeven Member Posts: 2
edited 2010-02-14 in SQL General
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?
We must change in order to survive

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Hi,

    Don't get me wrong but I think you misunderstand the place where you post your question.

    Mibuso site is about Microsoft Dynamics NAV (mostly). NAV (and other Microsoft software) uses Microsoft SQL Server as underlying DBMS. So "SQL General" forum is rather about MS SQL server problems/discussions (as only this DBMS is related to MS Dynamics * products).

    Good luck with finding solution to your problem. Perhaps someone from Mibuso community can help you with this - not me unfortunately :(

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories