如果你对SQL有所了解，只需创建一个这样的视图：



创建[NameOfView]视图为

SELECT table1。*，table2。*

FROM table1 JOIN table2 ON table1.SomeColumn = table2.SomeMatchingColumn



then使用NameOfView创建表适配器

If you know something about SQL, just create a View like this :

Create [NameOfView] View as
SELECT table1.*,table2.*
FROM table1 JOIN table2 ON table1.SomeColumn = table2.SomeMatchingColumn

then create your table adapter with NameOfView