I have done something like this:
[code]
select 'cust' AS LOGTYPE, name AS USERNAME, pass as PASSWORD
FROM
tblCustomer
UNION
select 'emp' AS LOGTYPE, username as USERNAME, password AS PASSWORD
from tblEmployee
UNION
select 'bus' AS LOGTYPE, username as USERNAME, password AS PASSWORD
from...