How to include rows with missing data in SQL Server 2008

Question

Let's say I have a table a table of employees and another employee_address.

Additionally, I have a table of employee_email_address (employees don't have to have an email)

select 
    employee.emp_id, 
    employee_address.address, 
    employee_email_address.email
from  
    employees 
inner join
    employee_address on employee.emp_id = employee_address.emp_id
inner join 
    employee_email_address on employee_email_address.emp_id = employee.emp_id

but what this query is giving me is only the employees who have an address AND an email address....

How can I include rows for which there is no email_address for the employees? (Note, the email address is not null)

Thanks.

Szörényi Ádám · Accepted Answer · 2015-03-06 23:45:21Z

1

Use left join instead of inner join.

answered Mar 6, 2015 at 23:45

Szörényi Ádám

1,26313 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

engr007 Over a year ago

I did, and it is still not adding these fields.

Gordon Linoff · Accepted Answer · 2015-03-07 03:01:44Z

1

Try this query:

Select e.emp_id, ea.address, eea.email
from employees e left join
     employee_address ea
     on ea.emp_id = e.emp_id left join
     employee_email_address eea 
     on eea.emp_id = e.emp_id;

answered Mar 7, 2015 at 3:01

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

How to include rows with missing data in SQL Server 2008

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related