Dataset with bridge table relationship

Hi,

I have a many to many relationship between 2 tables so therefore I have created a bridge table, to produce a one to many relationship.
My questions is how to I code this, so it shows in a datagrid?

You will have to use SQL to get a resultset. Something along the lines of this:

Code:

---

SELECT Table1.ColumnB, Table1.ColumnC, Table2.ColumnB, Table2.ColumnC FROM Table1, Table2 WHERE Table1.ColumnA = JoinTable.TestA AND Table2.ColumnA = JoinTable.TestB

---