Sql Server One column required two values MainProdcut and below this MainProduct all SubProduct

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

PK_MainPid MainProductName MainProductPrice
101 HP Laptop 36000
102 DELL Laptop 42000
103 SONY Laptop 45000

PK_SubPid FK_MainPid SubProductName SubProductPrice
01 101 DVD DRIVE 12000
02 101 USB Mouse 12000
03 101 Hard Disk 12000
04 102 DVD DRIVE 15000
05 102 USB Mouse 15000
06 102 Hard Disk 12000
07 103 DVD DRIVE 15000
08 103 USB Mouse 15000
09 103 Hard Disk 15000

Here I have two tables Main Product and SubProduct and I want to make report and I want output like this format means same column MainProduct (HP Laptop) and below this I want to display all sub product like(DVD DRIVE,USB Mouse,HardDisk)

PRODUCT PRICE
HP Laptop 36000
DVD DRIVE 12000
USB Mouse 12000
Hard Disk 12000
DELL Laptop 42000
DVD DRIVE 15000
USB Mouse 15000
Hard Disk 12000
SONY Laptop 45000
DVD DRIVE 15000
USB Mouse 15000
Hard Disk 15000

is it possible and how

Help me

Posted 2-May-11 18:16pm

arshad.magdum

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-05-02T18:56:00

You ask for a report here posting the table structure. :doh:

It does not work like this here. I am sorry but there is no quick question here. This sounds like your college project/assignment, you should put some effort.

We expect you to put some time in trying the issue that you are facing and then some time in formulating the question while posting here.

Here is what is expected by enquirers:
1. TRY first what you want to do!
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

To start with, make a query that returns all the data. It would be a simple inner join query. Use that query as input to the report.