{ :-O

Sweet mother of god. LEFT JOIN did essentially just what I needed.

This is proof that I have so, so much to learn about SQL. For the record, I really did look into this before posting, but I sometimes get lost in the examples given in my books.

THANK YOU.

Here was my final query:

select lan_user.*, lan_userws_rel. *, lan_ws.*
from lan_user
LEFT JOIN lan_userws_rel...

Good morning, folks. I'll get right to the point.

I have an MSSQL db with 3 tables. Table A holds users' data with logins and such. Table B holds workstations with machine names, hardware info, etc. Lastly, Table C holds record IDs from A and B in order to keep track of workstations paired to users. Some workstations don't have users yet, some users don't have workstations yet.

HOWEVER, I need to display all users WITH...