TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Hema Vasavada
NA
2
0
Database Query
Sep 1 2008 11:53 AM
If suppose I have one table Customers,fields Cus_Id as primary key,Cus_Name and Second table i.e., Orders table,Order_Id as primary key,Cus_Id reference to the Customers table,and Order_date.
Now my Question is that,I want to display the data like this:
Cus_Name 1996 1997 1998
Cus_1 8 5 1
Cus_2 5 3 2
Cus_3 4 0 4
Cus_4 11 25 0
And Year should be dynamically growable.
So I can judgement that,why Cus_4 has not been ordered in year 1998?
Suggestion is required........
Reply
Answers (
2
)
reading 1 piece of info from a selected index.
Calling an Oracle Stored Procedure using C#