In the below query, I have two fields (loan.ccmpy_id and the loan.scmpy_id) that relate to the company table's company.cmpy_id field. Pulling in the cmpy_name for the first cmpy_id was simple enough, but I am having difficulty pulling in the company name for the scmy_id field?
How do I do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.