reference multipal table records

i am trying to hack a SQL statement and i cant figure it out. will some one
please show me what im doing wrong. i want to reference multiple tables in a
report

SELECT DISTINCTROW [AssetsHardware].*, [AssetsSoftware].*,
[AssetsPrinters].*, [LastName] & ", " & [FirstName] AS [Employee Name] FROM
[Employees] RIGHT JOIN [AssetsHardware], [AssetsSoftware], [AssetsPrinters]
ON [Employees].[EmployeeID] = [AssetsHardware].[EmployeeID],
[AssetsSoftware]. [EmployeeID], [AssetsPrinters].[EmployeeID];