Office Connector: Join JC Job with PJ Job

SUGGESTED

I'm having trouble joining the JC Job Master file with the PJ Job master file. This seems like it would be straightforward joining "JOB" ON "JNUM" but it's not working. Any ideas?