Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Hi

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-21 : 11:22:28
Avilash writes "I am having 2 tables

Table 1

Date
ProductName
Productsales

Table 2

ProductName
Price

I want Output as Monthly sales Report


Productname Sum(Prodcutsales) Price "

X002548
Not Just a Number

15586 Posts

Posted - 2004-06-21 : 12:38:12
Then you better let us know what the date column is called...



Brett

8-)

EDIT:

quote:

But then it's flat-top, dirty bop, copin' a feel'
grubbin on the living room floor;
They send you off to college to try to gain
a little knowledge,
But all you want to do is learn how to score.



Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-06-21 : 15:41:36
Sounds like homework

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -