|
|
| Re: Get Source-Code for the eBook "BIRT: A Field Guide, 3rd Edition" [message #1693156 is a reply to message #1693139] |
Wed, 22 April 2015 03:08   |
Eclipse User |
|
|
|
Thanks for your reply.
I have solved the problem.
This is my working SQL-Code
SELECT
classicmodels.customers.customernumber,
classicmodels.customers.customername,
classicmodels.customers.addressline1,
classicmodels.customers.postalcode,
classicmodels.customers.city,
classicmodels.customers.country,
classicmodels.orders.ordernumber,
classicmodels.orderdetails.orderlinenumber,
classicmodels.orderdetails.productcode,
classicmodels.orderdetails.quantityordered,
classicmodels.orderdetails.priceeach
FROM classicmodels.customers
JOIN classicmodels.orders ON classicmodels.customers.customernumber = classicmodels.orders.customernumber
JOIN classicmodels.orderdetails ON classicmodels.orders.ordernumber = classicmodels.orderdetails.ordernumber
WHERE classicmodels.customers.customernumber BETWEEN 100 AND 120
ORDER BY classicmodels.customers.customernumber ASC, classicmodels.orders.ordernumber ASC, classicmodels.orderdetails.orderlinenumber ASC |
|
|
|
Powered by
FUDForum. Page generated in 0.07055 seconds
Home