I need to produce a login script that searches 3 tables in a DB and return the name of the table the result was from.
My database has many tables including the follwing 3:
Clients Managers Contractors.
I basically need to search through these 3 tables to find the match (or not) but them need to know what table they have come from. It would be easy if they were all in the same table with a identifier in the same row but the tables need to be constructed this may because of other factors.
My question is, can I return the name of the table the result came from without inserting an extra field in each of them with the table name in it so I can retrieve it with the search?
Once I know what table they are from I can assign differnt permissions.
Any ideas of a good query I can run to achieve this?
Just realized I had left the "tablename" out of the query (), and you needed that.
Here goes the changed code:
SELECT * FROM (SELECT ID,USERNAME,PASSWORD, "CLIENTS" AS TABLENAME FROM CLIENTS UNION SELECT ID,USERNAME,PASSWORD,"MANAGERS" AS TABLENAME FROM MANAGERS UNION SELECT ID,USERNAME,PASSWORD,"CONTRACTORS" AS TABLENAME FROM CONTRACTORS) WHERE (USERNAME="MySearchName") AND (PASSWORD="MySearchPassword");
Topic Locked
Posted - 20 February 2002 : 18:56:14
), and you needed that.