David,

> I am getting the following error : "Dynamic SQL generation is not supported against multiple base tables" when I try to update my SQL Database from my DataSet (which uses a SELECT Statement containing a JOIN).
>
>Does anyone have an easy way around this in Mere Mortals? Will I need to use Stored Procedures?
>
>Any replies are appreciated.

The most straightforward way is to used stored procedures. ADO.NET is not especially tuned for updating multiple back end tables from a single DataTable.

Regards,