You would need to create separate queries for each, similar to this:
SELECT U.* FROM Unions U WHERE U.UnionID = 1 SELECT E.* FROM Employees E INNER JOIN Unions U ON E.UnionID = U.UnionID WHERE UnionID = 1 SELECT C.* FROM Contracts C INNER JOIN Employees E ON E.EmployeeID = C.EmployeeID INNER JOIN Unions U ON E.UnionID = U.UnionID WHERE UnionID = 1
(the table names and join criteria are not the same as your data but hopefully you get the idea)
May be it would only be me who is unable to understand your requirements. Perhaps it would be helpful if you comeup with 1) sample data for all your tables. 2) PK and FKs of the tables 3) the required output or the desired operation should be done
That's a big help, although it's missing the definition for tblLabourFiles. Do you have any foreign keys defined between these tables? The script for those would help too.
Looking back on your original query, I noticed a number of join conditions were not specified (tblLabourFiles to employees somehow, tblLabourFilesUnion to tblUnionNames). You also have a number of tables listed that you don't extract data from, and aren't necessary to answer the query as I read it (e.g. tblReasons).
Also, you describe this as a "union" but what you've written is not a UNION in SQL terms. You're joining all these tables together and extracting different columns from each. Is that your intention?