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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SQL Statement
kwajahathydro
Member Posts: 88
in SQL General
Hi All,
I have a question here whereby i am trying to write an sql statement for the following as an example from Nav
1. Table: sales order (Asia Area)
Sales Order Number Customer Date
SO001 Singapore Faire Price 2017.1.14
SO002 China Wu Mei 2017.1.30
SO003 Singapore Giant 2017.3.8
2. Table: sales order Detail (Asia Area)
Sales Order Number Item Name Unit Price Quantity
SO001 TV 30” 1000 30
SO001 TV 35” 1200 20
SO002 AirCon 200 700 80
SO002 Washing Machine 300 900 50
SO003 TV 30” 950 60
SO003 AirCon 200 800 100
3. Table: Item (Singapore Item Master)
Item Name Description UoM
TV 30” Television 30” Set
TV 35” Television 35” Set
AirCon 200 Air Conditioner 200 PC
AirCon 500 Air Conditioner 500 PC
Oven 5KW Home Oven 5KW PC
how to write SQL statement (like, Select … From …) to export sales amount of Singapore items by monthly in 2017 Q1, and sorting by month and then amount, which includes zero amount item. And provide the result of your SQL statement.
Regards
khan
I have a question here whereby i am trying to write an sql statement for the following as an example from Nav
1. Table: sales order (Asia Area)
Sales Order Number Customer Date
SO001 Singapore Faire Price 2017.1.14
SO002 China Wu Mei 2017.1.30
SO003 Singapore Giant 2017.3.8
2. Table: sales order Detail (Asia Area)
Sales Order Number Item Name Unit Price Quantity
SO001 TV 30” 1000 30
SO001 TV 35” 1200 20
SO002 AirCon 200 700 80
SO002 Washing Machine 300 900 50
SO003 TV 30” 950 60
SO003 AirCon 200 800 100
3. Table: Item (Singapore Item Master)
Item Name Description UoM
TV 30” Television 30” Set
TV 35” Television 35” Set
AirCon 200 Air Conditioner 200 PC
AirCon 500 Air Conditioner 500 PC
Oven 5KW Home Oven 5KW PC
how to write SQL statement (like, Select … From …) to export sales amount of Singapore items by monthly in 2017 Q1, and sorting by month and then amount, which includes zero amount item. And provide the result of your SQL statement.
Regards
khan
0