MYSQL用值填充外部id

I have a printed table here, and I issue a query to attempt to join the tables where the Tech_id, clients_id, job_id, part_id should populate with corresponding key in their tables / column too.I have a printed table here, and I issue a q