Combining Multiple Database Customer Tables

[schoolboy]

If you are trying to EXTRACT that data, then there is no need to create new tables / fields... Just write a script that gathers it all up and produces it in the output you desire.

[abcschooldr]

Thank you for the quick replies! I am connecting the ZenCart database to Moodle external database authentication and enrollment. Moodle will only allow me to connect to 1 table. My customers do not create an account in ZenCart. I want to use their email address as a login user name and their zip code as a password. These are in 2 different tables.
Next I want that same table to list the correct course ordered. This is in a 3rd table. I also want the statutory required minimum time to start when they order.