I've got a successful set up with authentication against an external database but the data required for full enrolment is located in 2 tables - from one I get username, password and email and from the next I want to get first and last name.
Has anyone been able to sync with two tables?
The easiest way was to create new fields in my external database single table to accommodate Moodles limitations.
Since Moodle is looking for a single table, you could create a view in your external database that aggregates your two external tables into one database view. This is actually what we're doing for our external DB. I don't actually point to a table on our MS SQL Server. I point to a view that pulls in data from three other tables.