MySQL multiple tables and fields in Dialplan

My aim is reading a database for authentication and saving paths of a ‘record’.

Is there any way to connect multiple tables and fields (MySQL simple inserts & queries) to read and write in the dialplan? .

I’ve experimented using odbc combined with Mysql, but this is messy way to get two tables. And using CDR to write and Realtime to read seperatly also seems a long way round (as well as me not getting it to work yet - CDR unregistered?).

Perhaps via app_dbodbc or res_sqlite?



apologies for cross postings - user list did not get a result.