Table Joins... PLEASE HELP!!!!

[aaaaaaa2000]

I have two tables, one for employees and one for customers.

Customer Employee
---------- ---------
CustomerID [PK] EmployeeID [PK]
Name Name
Contact ..
.. Password
Password
Note

Both of these tables have many columns in them but the important ones are the EmployeeID, CustomerID and the Passwords.

I need to make a view(query, custom view) so that All of the Customer IDs and EmployeeIDs would be together in one column and all of their passwords would be in another column.

As a result I will have a two columned table with all Usernames(IDs) and Passwords


Please answer asap. I really need this right away.
Thanks for your time

 

[JarlH]

Check out UNION ALL.

 

[rac2]

SELECT name, password
FROM Customer

UNION ALL

SELECT name, password
FROM Employee

ORDER BY name