Simple Select: 2 tables - Inner Join

[brighteyes]

Hi... Great forum you have here. Glad i stumbled across it.

So... I have two tables: Systems and Employee. I am trying to pull all records from System. However, not all Systems.EmployeeID fields are populated , and the query only pulls records where Systems.EmployeeID is not null. What changes do I need to make to view all records? I want to view all systems regardless if System.EmployeeID is populated.

Here's my query:

SELECT Systems.ServiceTag, Systems.PartNumber, Systems.LineOfBusiness, Systems.MarketingCode, Systems.Version, Systems.ProjectName, Systems.Description, Employee.empFirstName+" "+Employee.empLastName AS NAME, Systems.Status
FROM Employee INNER JOIN Systems ON Employee.empID=Systems.empID;

Thanks!!

 

[Jon K]

Change INNER JOIN to RIGHT JOIN
.

 

[brighteyes]

Doh!! Well I understand joins now... thanks.. .Perfect!