471,108 Members | 1,279 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

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

Feb 25 '06 #1
2 974
"Wing" <li******@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.

Feb 25 '06 #2
I am doing my own homework, just need some knowledge that to start my
work.
thanks for comment.

Feb 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Job Lot | last post: by
2 posts views Thread by James | last post: by
3 posts views Thread by james | last post: by
1 post views Thread by Dennis Gearon | last post: by
5 posts views Thread by Regnab | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.