Just wondering if there is an easier way to do the following...
Each application has a different database, but each application also shares a core database. This core database has User access information/permissions, etc.

When performing a query it would be nice if I could do a join with the user_id from the application database and the core database to get, lets say, the user's name. Instead, currently, I have to select the rows from the application database, then for each row select the user's name from the core database. Just wondering if anyone knows of a better way to perform this query.

Thanks