|
Home > Archive > Microsoft SQL Server forum > February 2006 > Question about Joining 2 tables??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Question about Joining 2 tables??
|
|
|
| Hi everyone,
I have problem to join 2 tables together to show the selected results
into a datagrid.
table1 hosts all customer personal information.
table2 hosts all the trasaction records for each customer
table1 has fields such as "customerID", "CustomerName" and "TelNumber".
(customerID is primary key in table1)
table2 has fields such as "cusomterID", "ComponentPurchase" and
"Quantity"
table1
CustomerID CustomerName TelNumber
55 John 1234566
56 David 6589211
table2
CustomerID ComponentPurchase Quantity
55 componentA 10
55 componentB 5
55 componentC 1
56 componentA 2
how can i join these two tables and get the result datagrid that list
each customer personal information and the component he/she purchased
listed below his/her personal information?? such as look like following
one
--------------------------------------------
John 1234566
componentA 10
componentB 5
componentC 1
--------------------------------------------
David 6589211
componentA 2
-------------------------------------------
Could everyone give me some suggestion, or any article i can read?
thanks for your time
Wing
| |
| Eric J. Holtman 2006-02-25, 9:45 am |
| "Wing" <li.alwin@gmail.com> wrote in news:1140828715.240420.308800
@u72g2000cwu.googlegroups.com:
> Hi everyone,
>
> I have problem to join 2 tables together to show the selected results
> into a datagrid.
>
>
> Could everyone give me some suggestion, or any article i can read?
>
My suggestion:
Do your own homework. You'll learn more from the class that way.
| |
|
| I am doing my own homework, just need some knowledge that to start my
work.
thanks for comment.
|
|
|
|
|