One for all you pro's out there....!

[rell]

Hi, One for all you pro's out there! Try to get your heads round this one, The tables are:

Table 1 = Item

ItemCode (primary key)

Description
Format
Unit price
Stock Level

------------------
Table 4 = CustOrderItem

CustomerOrderNo (pk)(fk)
ItemCode(pk)(fk)

CustOrderQuantity
CustOrderUnitPrice
Comments
DateActioned

The query needed is to provide a list of ItemCode, Description, number and value of customer (number means the number of Customer Orders placed for the Item, 'value' is the total value of Customer Orders placed for the Item) placed for that ItemCode during the current month (the month when the query is actually run), and display details in order of ItemCode within descending average value (average is the average value of Customer Orders placed for the Item)

The Select statement must be able to be run month after month without being modified, ie it should not include embedded dates.

Go for it.......

 

[svanels]

Home work ? Steven van Els
SAvanEls@cq-link.sr

 

[rell]

Not quite, got exams coming up and attempting some past papers. Think I'm gonns fail! :-(

 

[rell]

IF YOU COULD HELP ME OUT WITH THIS IT WOULD BE APPRECIATED, EVEN JUST SOME TIPS .THANKS

 

[svanels]

Try out the ANSI SQL forum at

http://www.tek-tips.com

Steven van Els
SAvanEls@cq-link.sr