KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to know if a user has an entry in any of 2 related tables. Tables USER (user_id) EMPLOYEE (id, user_id) STUDENT (id, user_id) A User may have an employee and/or student entry. How can I get that info in one query? I tried: select * from [user] u inner join employee e on e.user_id = case when e.user_id is not NULL then u.user_id else null end inner join student s on s.user_id = case when s.user_id is not NULL then u.user_id else null end But it will return only users with entries in both tables. SQL Fiddle example
Tags (comma-separated)
Save Edits
Cancel