I have a XML
that exports two tables, now that XML
I want to import it to another table with the same fields, they are too much data that is why I exported it, I hope you can help me thanks.
This is my query
SELECT * FROM usuario INNER JOIN vehiculo on usuario.id = vehiculo.usuario_id
where usuario.id between 1 and 2
FOR XML raw,elements,root('xml')
Then that XML
I have to pass again to another database that have the same two tables with the same columns.
thanks.