This never matches. You aren’t confronting two columns, but a column and a string.
What you want is
attorney.firm_id = law_firm.firm_id
without the quotes
This never matches. You aren’t confronting two columns, but a column and a string.
What you want is
attorney.firm_id = law_firm.firm_id
without the quotes
actually, he already had it, in the ON clause