Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
SQL join problem
chrisssteeven
Member Posts: 2
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?
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
0
Comments
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
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03