Left Join 2 Datatable

[AnhTin]

Hi all I have 2 Datatable the fist (dtUser): have column UserID, Name, Address (10 rows) the second(dtOrder): have column OrderID, UserID (5) And 2 datatable haven't relationship How can i "Select * from dtOrder A LEFT JOIN dtUser B ON A.UserID = B.UserID" in new datatable by Asp.net ??

[pmarfleet]

Your question has nothing to do with ASP.NET. However, you can define parent/child relationships between DataTables by using the DataRelation[^] class.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Pankaj Garg]

SELECT * FROM dbo.dtOrder INNER JOIN dbo.dtuser ON dbo.dtOrder.UserID = dbo.dtuser.UserID

If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!