DataTable Joining

[TestVBnet]

I have got My 1st DataTable TableA from Database which is given below

Item       Place
  -------------------------
      ItemA      PlaceA
      ItemC      PlaceC

I have got My 2nd DataTable TableB from Database which is given below

Item       Status
---------------------------
      ItemB     
      ItemC      Complete

The New Data Table will Look Like Below

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      Complete

I am Using the following Code

Dim DT_A As DataTable
        DT_A = TableA.Copy()

        Dim DT_B As DataTable
        DT_B = TableB.Copy()

        DT_A.Merge(DT_B)

I am Getting Like below

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      
     ItemC                 Complete

But I am not Getting the Like Below Data Table

Item      Place       Status
-------------------------------------
     ItemA     PlaceA  
     ItemB                 Complete
     ItemC     PlaceC      Complete

Please Help.What is the Main Problem and Whats the Solution

Thanks in Advance

[adam_k]

You need to join the 2 tables in the query to the database. This will get you your result.

HINT: You'll need either LEFT or RIGHT join. INNER won't work for you.

Read here: http://msdn.microsoft.com/en-us/library/ms191517.aspx and here: http://msdn.microsoft.com/en-us/library/ms191472.aspx

[Netcode]

The JOIN should be part of your SQL Query