The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Classification of Vehicles:

 drop table PRODUCT_CAR;
    create table PRODUCT_CAR(Code varchar(100),Description  varchar(100),parent_id varchar(20))
    insert into PRODUCT_CAR select * from (
     select '0'  as code, 'car'                  as Description,''   as parent_id union all
     select '1'  as code, 'BMW'                  as Description,'0'  as parent_id union all
     select '2'  as code, 'BENZ'                 as Description,'0'  as parent_id union all
     select '3'  as code, 'VW'                   as Description,'0'  as parent_id union all
     select '4'  as code, 'Hummer'               as Description,'0'  as parent_id union all
     select 'B5' as code, 'BMW 5 series'         as Description,'1'  as parent_id union all
     select 'B6' as code, 'BMW 6 series'         as Description,'1'  as parent_id union all
     select 'B7' as code, 'BMW 7 series'         as Description,'1'  as parent_id union all
     select 'Z1' as code, 'BZ Home Series'       as Description,'3'  as parent_id union all
     select 'Z2' as code, 'BZ Sercial series'    as Description,'3'  as parent_id union all
     select '1A' as code, 'BZ A series'          as Description,'Z1' as parent_id union all
     select '1B' as code, 'BZ B series'          as Description,'Z1' as parent_id union all
     select 'ZS' as code, 'BZ S series'          as Description,'Z2' as parent_id union all
     select 'V1' as code, 'VW Home Series'       as Description,'ZS' as parent_id union all
     select 'V2' as code, 'vw Sercial series'    as Description,'3'  as parent_id union all
     select 'V3' as code, 'AUDIO Sercial series' as Description,'3'  as parent_id union all
     select 'V001' as code,  'VW SUVS series'    as Description,'V1' as parent_id union all
     select 'VA01' as code,  'AD HOME Sercial'   as Description,'V3' as parent_id union all
     select 'VA02' as code,  'AD SUVS Sercial'   as Description,'V3' as parent_id union all
     select 'VA21' as code,  'AD A Sercial'      as Description,'V3' as parent_id union all
     select 'VA211' as code, 'AD Q Sercial'      as Description,'VA02' as parent_id
    ) a;
    SELECT * FROM PRODUCT_CAR ORDER BY CODE ASC;

Sales Data:

create table SEll_CAR(
   Car_Code     varchar(100),
   Description  varchar(100),
   quantity     numeric(10),
   product_code varchar(20)
);
insert into sell_car select * from (
  select 'B53001'  as Car_code , 'BMW 535 LI luxury cars' as Description, '21'   as quantity, 'B5'    as product_code union all
  select 'B75001'  as Car_code , 'BMW 750 LI XDriver'     as Description, '200'  as quantity, 'B7'    as product_code union all
  select '21101'   as Car_code , 'AD  Q7 luxury cars'     as Description, '30'   as quantity, 'Va211' as product_code union all
  select 'VA211'   as Car_code , 'AD  A6 LI luxury cars'  as Description, '2'    as quantity, 'VA01'  as product_code union all
  select 'VW1001'  as Car_code , 'VW  Cross polo  '       as Description, '100'  as quantity, 'V1'    as product_code
) b;
select * from sell_car;

result:

PRODUCT_CAR.code  PRODUCT_CAR.Description  sell.Sell_SUM
1                 BMW                      221
2                 BENZ                     0
3                 vw                       132
4                 Hummer                   0

asked 19 Sep '13, 06:08

mfkpie8's gravatar image

mfkpie8
86404550
accept rate: 10%

closed 19 Sep '13, 08:31

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644

4

This forum is for answering questions about SQL Anywhere, not doing your homework.

(19 Sep '13, 07:49) Breck Carter
Replies hidden

Furthermore, I guess you have already posted the same here (and I'm not sure whether this is a "question" at all - or a nuisance):

http://sqlanywhere-forum.sap.com/questions/18168/how-i-can-use-of-recursive-query-results-help-thanks

(19 Sep '13, 08:32) Volker Barth

According to the brand (layer 1) according to sales situation

(03 Oct '13, 10:03) mfkpie8

The question has been closed for the following reason "Duplicate Question" by Volker Barth 19 Sep '13, 08:31

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×17

question asked: 19 Sep '13, 06:08

question was seen: 602 times

last updated: 03 Oct '13, 10:03