Whether my plan is effective?

[CstAn]

Hi, currently my working company have few web system that use for particular department, the system may use in inter department situation.

Currently, all the login was individual. This also the purpose that i want link all web system that user use only one acct for all web system.

each system was use own database and each database maintained their user.
All web system are using PHP and MySQL database.

my plan is, I create a database that maintenance the user login info for all the web system, each time user login must connect to this database and match their user name and password. If match then connect to the system database else disconnect all database.

any issued will caused?

How can i join two table from different database????
*PHP & MYSQL

[guelphdad]

You should not have a problem with what you want to do.

As for joining two tables from separate databases, you can do that if the user has permissions to select from both databases. then you just name the database as well as the table and column. As an example:


select
database1.table1.column1,
database3.table2.column4
from
database1.table1
inner join
database3.table2
on
columnA = columnB