Yes, but it'll be a simple example:
SELECT Customers.CUST_ID, Customers.CUST_Forename, Customers.CUST_Surname, Jobs.J_RefNum, Jobs.J_Model, Jobs.J_ReceivedBy, Jobs.J_DateRec, Jobs.J_FaultDesc,
Jobs.J_PassWinAdmin, Jobs.J_DataRecYN, Jobs.J_PowerSuppYN, JobStatus.JS_Status
INNER JOIN Jobs ON Jobs.J_RefNum = Customers.CUST_ID
You would need to issue a proper JOIN between each table that you want to associate, but the records must be of a compatible type and make logical sense to associate them with.
I inferred that relationship based on the where criteria. Inner joins require a match on the ON properties between both tables to be qualified for a match in the query. A LEFT join would require all records from the LHS table (the Customers in this example), and any associated in the RHS table (the jobs). And a RIGHT join would be the reverse.