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

"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.