Question
Joining Tables
I am trying to join five different tables. This table should
give me all the equipment that belongs to each employee. But
instead, I am getting only the information of those employees that
have all the equipment (PC, Laptop, printers and blackberry), NOT
the information of all of the employees no matter if they have
equipment or not. Here is what I'm doing.
SELECT [Employees].[EMPLOYEE_ID], [Employees].[FIRSTNAME], [Employees].[LASTNAME], [Employees].[OFFICE_ID], [PC].[PC_BARCODE], [Laptops].[LAPTOP_BARCODE], [Blackberries].[BLACKBERRY_BARCODE], [Printers].[PRINTER_BARCODE]
FROM (((Employees INNER JOIN Blackberries ON [Employees].[EMPLOYEE_ID]=[Blackberries].[EMPLOYEE_ID]) INNER JOIN Laptops ON [Employees].[EMPLOYEE_ID]=[Laptops].[EMPLOYEE_ID]) INNER JOIN PC ON [Employees].[EMPLOYEE_ID]=[PC].[EMPLOYEE_ID]) INNER JOIN Printers ON [Employees].[EMPLOYEE_ID]=[Printers].[EMPLOYEE_ID];
Any help will be appreciate it!
SELECT [Employees].[EMPLOYEE_ID], [Employees].[FIRSTNAME], [Employees].[LASTNAME], [Employees].[OFFICE_ID], [PC].[PC_BARCODE], [Laptops].[LAPTOP_BARCODE], [Blackberries].[BLACKBERRY_BARCODE], [Printers].[PRINTER_BARCODE]
FROM (((Employees INNER JOIN Blackberries ON [Employees].[EMPLOYEE_ID]=[Blackberries].[EMPLOYEE_ID]) INNER JOIN Laptops ON [Employees].[EMPLOYEE_ID]=[Laptops].[EMPLOYEE_ID]) INNER JOIN PC ON [Employees].[EMPLOYEE_ID]=[PC].[EMPLOYEE_ID]) INNER JOIN Printers ON [Employees].[EMPLOYEE_ID]=[Printers].[EMPLOYEE_ID];
Any help will be appreciate it!