MS SQL - Get data from primary key's table

Question

Example:

Table: one Column (PK): employee_ssn Column: employee_active bit

Table: two Column (pk): date Column (FK): employee_ssn Column: total_income Column: total_expenses

--

Selecting data from table two:

select * from two

In this example, how would I select for all employees with "1" for "employee_active"?

Answer 1

You need to JOIN your tables together.

SELECT  two.employee_ssn, two.total_income, two.Total_Expenses
FROM    Two
        INNER JOIN One
            ON one.Employee_ssn = two.Employee_ssn
WHERE   One.employee_active = 1;

More links on Joins

• Stackoverflow
• W3 Schools
• Wikipedia
• SQL Authority
• Technet

Answer 2

Try this !!

select * from table1 a inner join table2 b 
on a.employee_ssn=b.employee_SSN 
where a.employee_active =1