Insert / Update of record in a TableAdapter with Joins

Good Day.

This is working with DevExpress and I am implementing the data update through DataBindings and TableAdapters.

The problem is that the queries I require consist a lot of the Joins and it is not a viable option to use SubQuery's inside the query.

I want to know if there is any way to send a query with inner / left join and perform the update / insert / delete using the tableadapters.

This is the Select I'm using:

SELECT 
Codigo,
Valor$,
DescEsp,
ipTipo,
DescTipo,
P.Tipo,
ipUM,
uMedida,
ipArancel,
Fraccion,
TT.Tasa,
CantidadAImportar,
Valor$,
CantidadPermitida,
ValorAImportar 
FROM COMPPERMISO as C 
inner join PERMISOS P on P.idPermiso = ipPermiso 
inner join CODIGOS CD on C.ipCodigo = CD.idCodigo 
inner join Medidas M on idMedidas =ipUM 
inner join ARANCELES A on idArancel = ipArancel 
inner join TIPOS T on idTipos = ipTipo 
inner join TiposTasa TT on idTipoTasa = TipoTasa 
where idPermiso=195