Query mixing rows

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

:cool:

:slight_smile: