Hello all, this is my first experience with Views so please be gentle if what I'm asking is dumb. A view may not even be what is needed for this?
I have multiple databases (for this instance let's say there are 20 of them, in reality there will be a couple hundred) In each of these databases there is a 'users' table. Each of these users tables are structured exactly the same. These databases may, or may not reside on the same server, currently they are all on the same server but in the future it will expand to other servers.
I need (I think) to create a view that includes all the users tables combined. I want to do this so I can have a 'global' login form for users to use.
So the view would really only need to include the email address and the db info from which that email address came from.
My goal is for a visitor to submit the global login form, the script checks the view to see if the email address exists and then checks which db to use to login as then the script queries the correct db and verifies the user (the verification script is already written and functioning).
If there's a better way to do this I'm open to suggestions/ideas/pointers/advice/guidance. Thanks in advance!