So this can be done with datarelations. I have not use datarelations before so could you please tell me how should I create the relation to get same result than with this SQL-code?

SELECT a.customerID, a.Name, a.shop_id, ISNULL(sa.PCS1, 0) AS PCS1, ISNULL(sb.PCS2, 0) AS PCS2
FROM customers AS a
LEFT JOIN Shop1 AS sa ON (a.shop = sa.shop)
LEFT JOIN Shop2 AS sb ON (a.shop = sb.shop)

In my project I have 3 datatables with different data inside. I have datatables like:
Customers:

Customer number

Name

ID

123450

Customer A

169

987650

Customer B

753

orders in last week:

ID

PCS

169

7

753

3

and orders in sekond week in past:

ID

PCS

169

9

753

2

Now I want to combine these tables data to table like next:

Customer number

Name

ID

1 week

2 week

123450

Customer A

169

7

9

987650

Customer B

753

3

2

I know this can be done with datarelation or with SQL inner join but idont have any

I really have make a search of this but that seems like you dont have read my message really good. I was asking this for VB.NET not C# Thanks anyway Teemu H

There is something you can try: http://blogs.msdn.com/stevenpr/archive/2004/08/05/209390.aspx[^] Teh

How can i send email from pocket pc 2003 with vb.net cf2 Teemu H