Table 1 and Table 2 have matching columns. How do I join the 9th column from table 2 to table 1 based on the matches?
SELECT *
FROM tbl1
JOIN tbl2
  USING (
    acct_number,
    system,
    source,
    object,
    group,
    code,
    detail,
    routing,
    complexity
  );


But this is insanity. You should be reducing this to a sane primary key. Even if you're primary key is a natural key, this many columns is highly indicative of bad practice.